All notable changes to this project will be documented in this file. See Conventional Commits for commit guidelines.

• support SQLite aggregates for loading, filtering, sorting, calculations, and root query aggregates
• add grouped aggregate regression coverage for list defaults and root query aggregate kinds

• preserve aggregate relationship preparations, configured arguments, and attribute tenant scope
• respect relationship limits when filtering first and list aggregates

• support new string length functions by Zach Daniel

• allow write transactions per resource via write_transactions? (#223) by Conor Sinclair

• quote json_extract path segments to prevent JSON path traversal (CVE-2026-77846) by Zach Daniel

• use recursive comparison for json objects by Zach Daniel

• JSON-encode map literals wherever they appear in an expression (#222) by Alan McCann

• Handle is_distinct_from / is_not_distinct_from in the map-comparison path (#220) by Alan McCann

• don't match tenant attributes by default by Zach Daniel

• dedup index keys in migrations by Zach Daniel

• Implement list_expr/6: render list literals as json_array(...) (#221) by Alan McCann

• Support ecto_libsql (libSQL) as an alternative adapter (#212) by Alan McCann

• Use SQLite IN for large scalar list filters (#214) by Will Townsend

• ensure atomic updates properly update all fields by Zach Daniel

• bulk_create with upsert now updates update_timestamp fields by Michael Bärtschi

• bulk_create with upsert now updates update_timestamp fields (#207) by Michael Bärtschi

• Handle nil default values in migration generator by Zach Daniel

• don't double count renaming & adding attributes by Zach Daniel

• support positional name argument in generate_migrations by Zach Daniel

• read touch_update_defaults? from options instead of changeset context (#208) by Michael Bärtschi

• support nils_distinct? in identities by Zach Daniel

• handle map comparisons via json encoding. by Zach Daniel

• use custom string_length implementation for SQLite by Zach Daniel

• only migrate/rollback one repo at a time (#199) by ydo-kollins

• missing case in to_ecto (#198) by spicychickensauce

• ensure we always clean dev migrations by Zach Daniel

• raise clearer error on unsupported foreign key drops in SQLite migrations by Zach Daniel

• update to use bulk refs from latest ash by Zach Daniel

• Get rid of deprecation warnings (#188) by Jonatan Männchen

• ignore unkown option in generate_migrations task #180 (#181) by Abdessabour Moutik

• generate_migrations --dev duplicating migration files (#173) by Georges Dubus

• override default implementation of string trim test by Zach Daniel

• Reverse migrations order when reverting dev migrations (#167) by Kenneth Kostrešević

• update ecto & ecto_sql by Zach Daniel

• make rollback more reliable by using --to instead of -n by Zach Daniel

• support update_query and destroy_query by Zach Daniel

• properly apply filters on destroy & update by Zach Daniel

• properly fetch options in installer

• strict table support (#157)

• support new PendingCodegen error

• properly fetch options in installer

• --dev codegen flag (#154)

• various fixes around parameterized type data shape change

• Remove unused :inflex dependency

• Fix leftover reference to Inflex after it was moved to Igniter instead

• Fix igniter deprecation warning. (#152)

• ensure upsert_fields honor update_defaults

• ensure all upsert_fields are accounted for

• Handle empty upsert fields (#135)

• remove list literal usage for in in ash_sqlite

• use AshSql for running aggregate queries

• update ash version for better aggregate support validation

• Remove a postgresql specific configuration from ash_sqlite.install (#103)

• add installer for sqlite

• make igniter optional

• improve dry_run logic and fix priv path setup

• honor repo configs and add snapshot configs

• don't raise error on codegen with no domains

• installer: use correct module name in the DataCase moduledocs. (#82)

• add --repo option to installer, warn on clashing existing repo

• modify mix task aliases according to installer

• add igniter-based AshSqlite.Install mix task (#66)

• fix warnings from latest igniter updates

• use Ecto.ParameterizedType.init/2

• handle new/old ecto parameterized type format

• properly scope deletes to the records in question

• update ash_sqlite to get ilike behavior fix

• support contains function

• reenable mix tasks that we need to call

• support mix ash.rollback

• support Ash 3.0, leverage ash_sql package

• fix datetime migration type discovery

• add SqliteMigrationDefault

• support query aggregates

• Port and adjust AshPostgres to AshSqlite