Changelog

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

[4.1.0] - 2026-06-06

Added

• select.not_where: sets a NotWhere clause on a SELECT query, allowing negated WHERE conditions with AND semantics.

• select.not_having: sets a NotWhere clause on the HAVING portion of a SELECT query, for negated aggregation filters.

• delete.not_where: sets a NotWhere clause on a DELETE query, allowing negated WHERE conditions with AND semantics.

• update.not_where: sets a NotWhere clause on an UPDATE query, allowing negated WHERE conditions with AND semantics.

Changed

• Updated XOR documentation across select, update, and delete modules to clarify that Cake implements xor using a custom OR / AND / NOT expansion on all four adapters (🐘PostgreSQL, 🪶SQLite, 🦭MariaDB, 🐬MySQL) rather than native XOR. Entries now reference where.xor_parity for odd-parity XOR use cases.

• Updated join documentation in both join.gleam and internal/read_query.gleam to explain how to make joins exclusive using additional WHERE filters (e.g., LEFT JOIN + WHERE b.key IS NULL for exclusive left joins).

Documentation

• Improved module documentation for builder APIs.
• Added mermaid.js bundle (assets/mermaid.bundle.js) for rendering diagrams in documentation.
• Updated README and other documentation files.

[4.0.0] - 2026-05-30

Breaking changes

• [BREAKING] where.xor semantics unified to “exactly one” across all dialects. Previously, 🦭MariaDB and 🐬MySQL used the engines’ native XOR operator, which evaluates left-to-right and returns TRUE when an odd number of operands are true (odd-parity semantics). 🐘PostgreSQL and 🪶SQLite emulated xor as exactly one condition being true via a combinatorial expansion. These two semantics are equivalent for two operands but diverge for three or more.

  🦭MariaDB/🐬MySQL now use the same combinatorial “exactly one” expansion as 🐘PostgreSQL/🪶SQLite, making where.xor consistent across all four dialects. Any code that relied on the native-XOR (odd-parity) behaviour of xor on 🦭MariaDB or 🐬MySQL with three or more conditions will observe different query results after upgrading.

• [BREAKING] where module parameter labels renamed. The functions where.float, where.int, where.string, and where.date had their external parameter labels renamed from v to value. Any call site using named-argument syntax (e.g. where.float(v: 1.0)) must be updated to where.float(value: 1.0). Positional call sites are unaffected.

  Note: Similar internal variable name changes were made in insert, update, and fragment modules for consistency (e.g., vl → value, col → column, str → string, prms → params), but these do not affect external APIs since the external labels remained the same.

Added

• where.xor_parity: a new function implementing odd-parity XOR (returns TRUE when an odd number of conditions are true). On 🦭MariaDB and 🐬MySQL it delegates to the engines’ native left-to-right XOR operator; on 🐘PostgreSQL it uses ((cond)::int + …) % 2 = 1; on 🪶SQLite it uses the same arithmetic without casts. NULL propagates through the expression on all four dialects, matching native XOR behaviour. Prefer xor_parity over xor when targeting three or more conditions and odd-count semantics are required.

• where.bool: creates a WhereValue from a runtime Bool variable. Complements the existing where.true() and where.false() constants.

• where.neq, where.neq_any_query, where.neq_all_query: not-equal comparison functions, emitting <>, <> ANY, and <> ALL respectively. neq_any_query and neq_all_query are not supported by 🪶SQLite.

• fragment.date, insert.date, update.set_date: convenience constructors for calendar.Date values, bringing date support in line with the other param-creating helpers across all builder modules.

Fixed

• insert.on_constraint_conflict_ignore and insert.on_constraint_conflict_update emitted wrong SQL: queries using InsertConflictTargetConstraint produced ON CONFLICT (constraint_name) instead of the correct ON CONFLICT ON CONSTRAINT constraint_name. The generated SQL was invalid and rejected by the database.

• Epilog silently discarded in write queries when a single-line comment is set: in INSERT, UPDATE, and DELETE query builders, comment_apply was called before epilog_apply. When the comment used the -- single-line style, the SQL parser treated everything after -- on the same line — including the epilog — as a comment, silently dropping it. The order is now … <epilog> -- <comment>, consistent with the existing SELECT and COMBINED builders.

• INSERT modifier placed after the column list instead of before INTO: setting a modifier via insert.modifier produced invalid SQL such as INSERT INTO cats (name) OR REPLACE VALUES ($1). The modifier is now emitted between INSERT and INTO on all four dialects, giving the correct form INSERT OR REPLACE INTO cats (name) VALUES ($1). The fix also covers the 🦭MariaDB / 🐬MySQL INSERT IGNORE fallback path, where a user-supplied priority modifier (e.g. LOW_PRIORITY) is now correctly placed before IGNORE INTO: INSERT LOW_PRIORITY IGNORE INTO ….

• select.order_by_asc_nulls_last, select.replace_order_by_asc_nulls_last, select.order_by_desc_nulls_last, select.replace_order_by_desc_nulls_last emitted NULLS FIRST instead of NULLS LAST: all four functions passed the wrong OrderByDirection variant internally, causing e.g. ORDER BY col ASC NULLS FIRST to be emitted when NULLS LAST was requested. The equivalent functions in combined were unaffected.

• Fixed examples to run without tinkering.

Removed

• Documentation references to gmysql have been removed as the package appears unmaintained. This is not a breaking change — gmysql was never a dependency, only mentioned as an adapter option in documentation. Users of older Cake versions may still be able to use it.

[3.0.0] - 2026-04-29

• Added support for fragments in Inserts and Updates. Thanks to @qwexvf. This adds constructors to the public InsertValue / UpdateSet union types, which can break downstream compilation for exhaustive pattern matches.

  This is MOST LIKELY not a breaking change, if only the builder functions have been used to construct inserts.

[2.2.2] - 2026-04-26

• Update Cake’s internal query builder to remove let assert usage in prepared fragment building and unreachable panic.

[2.2.1] - 2026-04-18

• Make compatible with recent gleam stdlib versions.

[2.2.0] - 2025-10-31

• Add Date support based on gleam_time’s calendar.Date.

[2.1.3] - 2025-07-28

• Fix demos to use recent dynamic decoders and library versions.

[2.1.2] - 2025-07-09

• Utilize pog ~> 4.0.0 dependency in tests.

[2.1.1] - 2025-04-02

• Update deps, including latest stdlib.
• Only support Gleam 1.9.0+.
• BREAKING spelling fix: Renamed InsertConfictTarget to InsertConflictTarget.
• Relaxed type arg.

[2.1.0] - 2024-11-14

• Added convenience functions to select module to select columns by col names:
  • cols
  • replace_select_cols
  • col
  • replace_select_col
• Replaced dev/test and adapter target gleam_pgo with pgo dependency.
• Updated demos.

[2.0.2] - 2024-11-03

• [BREAKING]: Renamed select.offset function’s offst label to offset
• Updated test runner to target lowest and highest Erlang and Gleam versions supported:
  • Lowest is at the moment Erlang/OTP 26 and Gleam 1.4
• Updated dependencies
• Fixed typos

[2.0.1] - 2024-10-19

• Improved Readme

[2.0.0] - 2024-10-19

• Breaking changes:
  • Renamed cake.cake_read_query to cake.to_read_query
  • Renamed cake.cake_write_query to cake.to_write_query
  • Renamed cake.cake_query_to_prepared_statement to cake.to_prepared_statement

[1.1.2] - 2024-08-30

• Consistent dialect function names across all 4 RDBMS, fixed/renamed functions:
  • postgres_dialect/read_cake_query_to_prepared_statement => postgres_dialect/cake_query_to_prepared_statement
  • postgres_dialect/query_to_prepared_statement => postgres_dialect/read_query_to_prepared_statement
  • sqlite_dialect/read_cake_query_to_prepared_statement => sqlite_dialect/cake_query_to_prepared_statement
  • sqlite_dialect/query_to_prepared_statement => sqlite_dialect/read_query_to_prepared_statement
  • Note that while this a breaking change, the compiler will complain and the fix is trivial.

[1.1.1] - 2024-08-09

• Fix gleam min version to 1.3.0 to enable gleam add cake@1 to work.

[1.1.0] - 2024-08-09

• Added join.left_lateral and join.inner_lateral and join.cross_lateral support LATERAL JOINs available on 🐘PostgreSQL 9.3+ and recent 🐬MySQL versions. NOTICE: You may also use LATERAL literally to prefix table names in FROM clauses with multiple tables.

[1.0.1] - 2024-07-26

• Breaking but very small bug fix change: insert.on_columns_conflict_ignore specifies its column list via the columns label instead of column label.

[1.0.0] - 2024-07-24

• 1.0.0 stable release

[1.0.0-rc.0] - 2024-07-23

• insert.on_columns_conflict_update change the column label to columns.
• Added UPDATE demo.
• Added INSERT ON CONFLICT UPDATE demo.
• Added SELECT with JOIN demo.
• Added a demo using Fragment and PreparedStatement.
• Added more public utility functions to the fragment module.
• Removed glacier dev-dependency to speed up compilation.
• Moved demo apps into sub dir.
• Fixed a few path bugs in docs.

[0.15.0] - 2024-07-23

In the wake of making this library less verbose and more consistent be aware about a few slight breaking changes around mostly inserts, updates and deletes.

• Renamed caster argument to encoder within module insert.
• Renamed a lot of public function args to be consistent across the library.
• Added INSERT demo.
• Added DELETE demo.
• Changed insert param generation to automatically wrap.
• Changed update param functions to automatically wrap. Renamed them slightly.

[0.14.0] - 2024-07-19

• Added more utility to the where module, such as where.none, where.true and where.false.
• Fixed unit tests around INSERT...ON CONFLICT...UPDATE with WHERE clause.
• Renamed update.set_many_to_expression to update.sets_to_expression and update.set_many_to_sub_query to update.sets_to_sub_query.
• Renamed union_many to unions, union_all_many to unions_all, except_many to excepts, except_all_many to excepts_all, and intersect_many to intersects, intersect_all_many to intersects_all in module combined.
• Made where.similar_to escape_char an argument.

[0.13.0] - 2024-07-12

• Added where.in_query which allows to use a sub-query as the right hand side of an IN clause.
• Added where.sub_query which allows to use a sub-query as a WhereValue.

[0.12.0] - 2024-07-12

• Re-export types which can be used in public APIs, this should hopefully close the last gaps to never be required to use cake/internal/* modules.

  In case you are tempted to do so, please get in touch to see what we can do about it.

[0.11.0] - 2024-07-11

• Renamed Query and the internal query module to ReadQuery and read_query.
• Fixed some issues around upserts (INSERT ON CONFLICT UPDATE).
• Moved internal/params module into public namespace.

[0.10.1] - 2024-07-10

• Rename dialects such as postgres to postgres_dialect.
• Fix demos and tests to use public APIs instead of internal ones.

[0.10.0] - 2024-07-09

• Provide public API to access the generated SQL and prepared statement parameters in the base cake and new dialect modules.

[0.9.2] - 2024-07-07

• Added more more applications.
• Added tests and snapshots for upserts.

[0.9.1] - 2024-07-05

• Fix test suite.

[0.9.0] - 2024-07-05

• Improved documentation.
• Added demo app abstraction.
• Added first runnable demo for SELECT and decode.

[0.8.0] - 2024-07-03

• Flattened the query interface/DSL modules into the base namespace of cake/.
• Moved some modules only used internally into cake/internal/ namespace.
• Fixed and improved test suite for DELETE statements.
• Improved general documentation.

[0.7.0] - 2024-07-01

• Improved builder flexibility for inserts and updates.
• Added documentation for the insert, update and delete interface modules.
• Improved tests for UPDATE.
• Renamed select.groups_by to select.group_bys.
• Fixed bugs when updating with sub-queries, where specifying a sub_query while setting update columns to vales would remove all other settings.

[0.6.0] - 2024-06-27

• Added 🐬MySQL independent of 🦭MariaDB as first class supported.

[0.5.0] - 2024-06-26

• Fixed github CI and docker compose testing against 🐘PostgreSQL and 🦭MariaDB.
• Locally you should be able to install docker and then just run: bin/docker/detached/ and then gleam test.
• Relaxed licence from AGPL 3.0 to Mozilla Public License 2.0 (MPL-2.0).

[0.4.0] - 2024-06-22

• Added support for deletes and interface modules for insert, update, delete ontop of the existing select and combined interface modules.
• Added support for 🦭MariaDB and 🐬MySQL.
• Removed the hard dependency on any RDBMS specific library. These are now only required when developing and testing this library, but when running you can chose any of the following adapters:
  • pog
  • sqlight
  • gmysql

[0.3.0] - 2024-06-19

• Fixes around inserts, updates, moved a lot of deps to dev deps.

[0.2.0] - 2024-06-19

• A lot of polishing, support for inserts and updates.

[0.1.0] - 2024-05-22

• First preview / demo.