v0.3.0

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

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.

v0.1.0

Initial release.