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

• remap nested selects when sort requires a subquery

• don't create dynamics for map atomics where there are no expressions

• only use jsonb_build_object for expressions, not literals

• various fixes to retain lateral join context

• carry over tenant in joined queries

• select dynamics uses __new_ prefix

• add auto dispatch of dynamic_expr calls to behaviour module (#33)

• add auto dispatch of dynamic_expr calls to behaviour module

• match on new & old parameterized types

• support selecting atomic results into a subquery, and using those as the atomic values

• handle anonymous sorting aggregates

• properly set aggregate source binding when adding aggregate calculations

• use period notation to access aggregate context fields (#30)

• use SQL standard = instead of non standard == (#28)

• don't use fragment("1") because ecto requires a proper select

• use calculation context, and set calculation constraints for aggregates

• don't use ilike if its not supported

• use type for now expr if available

• use manual relationship impl for exists subqueries

• hydrate & fill template for related queries

• properly support custom expressions

• fix argument order in AshSql.Bindings.default_bindings/4

• query_with_atomics pattern matching error

• fix argument order in AshSql.Bindings.default_bindings/4

• better inner-join-ability detection

• better type casting logic

• ensure tenant is properly set in aggregates

• properly pass context through when expanding calculations in aggregates

• optimize contains when used with literal strings

• make strpos_function overridable (sqlite uses instr)

• handle non-literal lists in string join

• ensure that from_many? is properly honored

• ensure applied query gets joined

• apply related filter inside of related subquery

• apply aggregate filters on first join aggregates

• don't use to_tenant

• loosen elixir requirements

• automatically wrap fragments in parenthesis

• remove unnecessary parenthesis from builtin fragments

• loosen ash rc restriction

• fixes for ash_postgres

• refactoring out and parameterization to support ash_sqlite

• remove postgres-specific copy-pasta

• extract a bunch of things out of AshPostgres