Bisql

Bisql (pronounced báisikl 🚲) is a SQL-first, SQL-only, SQL-obsessed data access toolkit for Clojure.

Write real SQL. Keep it executable. Generate the boring parts.

• Query templates remain valid, executable SQL.
• Typical index-friendly queries are generated automatically, as comprehensively as possible.

No query builder
No data mapper
No hidden SQL
No boilerplate SQL

Installation

The full Installation guide lives here:

• docs/02-installation.md
• https://hatappo.github.io/bisql/docs/installation/

Getting Started

The full Getting Started guide lives here:

• docs/03-getting-started.md
• https://hatappo.github.io/bisql/docs/getting-started/

Quick Example

See the end-to-end sample project here:

• https://github.com/hatappo/bisql-example

It shows a practical flow:

• generate CRUD SQL from a PostgreSQL schema
• generate matching function namespace files
• execute one generated query
• copy one generated query into a hand-written SQL template
• execute the customized query

Development

For local setup, tasks, and dev workflow, see:

• docs/dev-local-development.md

Roadmap

• Support a very small expression language to improve expressiveness in if conditions.
• Add Malli integration.
• Support databases beyond PostgreSQL.
• Compile analyzed SQL templates into reusable renderer functions for lower runtime overhead.
  • Simplify emitted renderer forms further, especially around branch and loop body handling.
  • Reduce helper calls in emitted code where fragment normalization is still delegated.
  • Restrict bisql/DEFAULT to valid SQL value contexts if context-aware rendering becomes necessary.
  • Detect dangerous nil comparisons consistently in WHERE / HAVING clauses instead of letting expressions such as = NULL, LIKE NULL, or IN (NULL) silently behave unexpectedly. This likely needs stricter SQL context parsing, because = NULL is dangerous in WHERE / HAVING but can still be valid assignment syntax in SET.