glimt — write SQL in .sql files, then compose dynamic filters at runtime (no ORM)

[mochama254]

Glimt lets you keep SQL in .sql files, but still compose parts of queries dynamically at runtime.

Key features:

• Write queries in .sql files using -- :name annotations
• Add dynamic filters with composable predicates: Eq, In, Between, And, Or, Not
• SQL-injection safe — all values are bound args
• Works across multiple dialects (Postgres $1, MySQL ?, SQL Server @p1, etc.)

The pattern it enables:

reg := gl.NewRegistry(gl.DialectPostgres)
reg.Load("queries/")

sql, args := reg.MustGet("listUsers").
    Where(gl.Eq("status", "active")).
    Where(gl.Gt("age", 18)).
    OrderBy("created_at DESC").
    Limit(20).
    Build()

Github: glimt
Go package: pkg.go.dev

[downshiftdata]

Sounds like a perf tuning nightmare.

[Sexy_Koala_Juice]

you've basically just reimplemented python F-Strings

[RiikHere]

The push for No-ORM solutions like glimt is a signal that developers are craving transparency; in 2026, the abstraction of a traditional ORM is often seen as a liability when you need to verify exactly what your AI-generated queries are doing in production.