Change Log

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

v0.2.32 (2024-08-31)

Bug Fixes:

properly handle deeply nested maps in bulk updates
don't use distinct inside of an exists

v0.2.31 (2024-08-26)

Bug Fixes:

use correct subquery root binding when joining for aggregates

v0.2.30 (2024-08-09)

Bug Fixes:

properly handle nested exists aggregates
select 1 in exists queries

v0.2.29 (2024-07-30)

Bug Fixes:

properly scope exists queries & joins with from_many? joins

v0.2.28 (2024-07-27)

Bug Fixes:

properly cast typed expressions
don't ever case datetime to timestamp

v0.2.27 (2024-07-25)

Improvements:

avoid a bunch of double casting of operands

v0.2.26 (2024-07-23)

Bug Fixes:

don't accidentally mix updates/params when building changes

v0.2.25 (2024-07-22)

Bug Fixes:

track subqueries while selecting atomics

v0.2.24 (2024-07-17)

Bug Fixes:

properly determine parent_as bindings for nested joins

v0.2.23 (2024-07-17)

Bug Fixes:

fix build
properly expand resource calculation/aggregates in fields

v0.2.22 (2024-07-16)

Bug Fixes:

properly adjust calculation expressions before adding to query
properly traverse nested maps in non-select contexts
pass correct resource down when adding calculation fields

v0.2.21 (2024-07-16)

Bug Fixes:

move FILTER outside of array_agg aggregation
properly honor include_nil? option on sorted first aggregates

v0.2.20 (2024-07-15)

Bug Fixes:

don't set load on anonymous aggregates

v0.2.19 (2024-07-15)

Bug Fixes:

match on old return types for determine_types code

v0.2.18 (2024-07-15)

Bug Fixes:

properly set aggregate query context

v0.2.17 (2024-07-14)

Improvements:

use determine_types/3 in callback

v0.2.16 (2024-07-14)

Bug Fixes:

cast atomics when creating expressions

Improvements:

support latest format for type determination type

v0.2.15 (2024-07-13)

Bug Fixes:

use original field for type signal when selecting atomics

v0.2.14 (2024-07-13)

Improvements:

use explicit NULL fragment in error type hints

v0.2.13 (2024-07-12)

Bug Fixes:

use expression type for atomic updates

v0.2.12 (2024-07-12)

Bug Fixes:

properly handle nested nil filters in boolean statements

v0.2.11 (2024-07-11)

Improvements:

select pkey so data layers don't have to

v0.2.10 (2024-07-08)

Bug Fixes:

ensure selected atomics are also reversed

v0.2.9 (2024-07-08)

Bug Fixes:

retain original order for atomics statements

v0.2.8 (2024-07-06)

Improvements:

handle {:array, :map} stored as :map

v0.2.7 (2024-06-27)

Bug Fixes:

prefer resource's static prefix over current query's prefix

v0.2.6 (2024-06-18)

Bug Fixes:

ensure we always honor atomics_at_binding option from data layer

v0.2.5 (2024-06-13)

Bug Fixes:

properly remap selects on nested subqueries

v0.2.4 (2024-06-13)

Bug Fixes:

remap nested selects when sort requires a subquery
don't create dynamics for map atomics where there are no expressions

Improvements:

only use jsonb_build_object for expressions, not literals

v0.2.3 (2024-06-06)

Bug Fixes:

various fixes to retain lateral join context

v0.2.2 (2024-06-05)

Bug Fixes:

carry over tenant in joined queries

v0.2.1 (2024-06-02)

Improvements:

select dynamics uses __new_ prefix

v0.2.0 (2024-05-29)

Features:

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

Bug Fixes:

match on new & old parameterized types

Improvements:

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

v0.1.3 (2024-05-22)

Bug Fixes:

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)

v0.1.2 (2024-05-10)

v0.1.1-rc.20 (2024-05-08)

Bug Fixes:

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

v0.1.1-rc.19 (2024-05-05)

Bug Fixes:

use calculation context, and set calculation constraints for aggregates

v0.1.1-rc.18 (2024-05-05)

Bug Fixes:

don't use ilike if its not supported
use type for now expr if available

v0.1.1-rc.17 (2024-05-02)

Bug Fixes:

use manual relationship impl for exists subqueries

v0.1.1-rc.16 (2024-05-01)

Bug Fixes:

hydrate & fill template for related queries

v0.1.1-rc.15 (2024-04-29)

Bug Fixes:

properly support custom expressions

v0.1.1-rc.14 (2024-04-29)

Bug Fixes:

fix argument order in AshSql.Bindings.default_bindings/4
query_with_atomics pattern matching error
fix argument order in AshSql.Bindings.default_bindings/4

v0.1.1-rc.13 (2024-04-27)

Improvements:

better inner-join-ability detection

v0.1.1-rc.12 (2024-04-26)

Improvements:

better type casting logic

v0.1.1-rc.11 (2024-04-23)

Bug Fixes:

ensure tenant is properly set in aggregates
properly pass context through when expanding calculations in aggregates

v0.1.1-rc.10 (2024-04-22)

Improvements:

optimize contains when used with literal strings

v0.1.1-rc.9 (2024-04-22)

Bug Fixes:

make strpos_function overridable (sqlite uses instr)

v0.1.1-rc.8 (2024-04-22)

Bug Fixes:

handle non-literal lists in string join

v0.1.1-rc.7 (2024-04-20)

Bug Fixes:

ensure that from_many? is properly honored
ensure applied query gets joined
apply related filter inside of related subquery

v0.1.1-rc.6 (2024-04-12)

Improvements:

apply aggregate filters on first join aggregates

v0.1.1-rc.5 (2024-04-11)

Bug Fixes:

don't use to_tenant
loosen elixir requirements

Improvements:

automatically wrap fragments in parenthesis
remove unnecessary parenthesis from builtin fragments

v0.1.1-rc.4 (2024-04-05)

Improvements:

loosen ash rc restriction

v0.1.1-rc.3 (2024-04-01)

Bug Fixes:

fixes for ash_postgres

v0.1.1-rc.2 (2024-04-01)

Improvements:

refactoring out and parameterization to support ash_sqlite

v0.1.1-rc.1 (2024-04-01)

Improvements:

remove postgres-specific copy-pasta

v0.1.1-rc.0 (2024-04-01)

v0.1.0 (2024-04-01)

Improvements:

extract a bunch of things out of AshPostgres