Changelog

v0.6.0 (2026-10-06)

Enhancement

• Added SQL.transaction/2 which takes a keyword list of options as the first argument.
• Connection pool has been refactored and improved performance.
• A new benchmaking tool has been released: sql_bench.
• Encoding and decoding is now specializad at compile-time which has improved performance.

v0.5.0 (2026-03-31)

Enhancement

• SQL are now self-hosted with its own PostgreSQL driver and connection pool.
• Added SQL.transaction/1
• Added SQL.stream/2

v0.4.0 (2025-10-18)

Enhancement

• Improved SQL lexing performance with over 50% 91dc464.
• Added warnings for unknown operators 5bd7ec3.
• Added SQL.map/2 and implemented enumerable for SQL a646203.
• Added SQL Mix.Task.Compiler for sql files 4ce5b24.
• Added syntax highlighting when inspecting %SQL{} and in compiletime warnings.
• Improved compilation times.

v0.3.0 (2025-08-01)

Enhancement

• Improve SQL generation with over 100x compared to Ecto #12, #19.
• Fix bug for complex CTE #15. Thanks to @kafaichoi
• Support for PostgresSQL GiST operators #18. Thanks to @ibarchenkov
• float and integer nodes have now become numeric with metadata to distinguish sign, whole and fractional #19.
• keyword nodes are now ident with metadata distinguish if it's a keyword #19.
• SQL.Lexer.lex/4 now returns {:ok, context, tokens} #19.
• SQL.Parser.parse/1 has become SQL.Parser.parse/2 and takes tokens and context from SQL.Lexer.lex/4 and returns {:ok, context, tokens} or raises an error #19.
• Support for compile time warnings on missing relations in a query. #22
• mix sql.get creates a lock file which are used to generate warnings at compile time. #22
• Support SQL formatting. #22

Deprecation

• token_to_string/2 is deprecated in favor of to_iodata/3 #22.

v0.2.0 (2025-05-04)

Enhancement

• SQL 2016 conformance #6.
• Lexer and Parser generated from the SQL 2023 BNF #5.
• Added SQL.Token behaviour used to implement adapters #5.
• ANSI adapter #5.
• MySQL adapter #5.
• PostgreSQL adapter #5.
• TDS adapter #5.
• Improve SQL generation with 57-344x compared to Ecto #7 #4.
• Ensure inspect follows the standard representation #4.
• Ensure storage is setup when running benchmarks #5.

Deprecation

• token_to_sql/2 is deprecated in favor of SQL.Token behaviour token_to_string/2 #11.

v0.1.0 (2025-03-01)

Initial release.