Packages
ash_sql
0.8.0
0.8.0
0.7.6
0.7.5
0.7.4
0.7.3
0.7.2
0.7.1
0.7.0
0.6.9
0.6.8
0.6.7
0.6.6
0.6.5
0.6.4
0.6.3
0.6.2
0.6.1
0.6.0
0.5.5
0.5.4
0.5.3
0.5.2
0.5.1
0.5.0
0.4.5
0.4.4
0.4.3
0.4.2
0.4.1
0.4.0
0.3.16
0.3.15
0.3.14
0.3.13
0.3.12
0.3.11
0.3.10
0.3.9
0.3.8
0.3.7
0.3.6
0.3.5
0.3.4
0.3.3
0.3.2
0.3.1
0.3.0
0.2.93
0.2.92
0.2.91
0.2.90
0.2.89
0.2.88
0.2.87
0.2.86
0.2.85
0.2.84
0.2.83
0.2.82
0.2.81
0.2.80
0.2.79
0.2.78
0.2.77
0.2.76
0.2.75
0.2.74
0.2.73
0.2.72
0.2.71
0.2.70
0.2.69
0.2.68
0.2.67
0.2.66
0.2.65
0.2.64
0.2.63
0.2.62
0.2.61
0.2.60
0.2.59
0.2.58
0.2.57
0.2.56
0.2.55
0.2.54
0.2.53
0.2.52
0.2.51
0.2.50
0.2.49
0.2.48
0.2.47
0.2.46
0.2.45
0.2.44
0.2.43
0.2.42
0.2.41
0.2.40
0.2.39
0.2.38
0.2.37
0.2.36
0.2.35
0.2.34
0.2.33
0.2.32
0.2.31
0.2.30
0.2.29
0.2.28
0.2.27
0.2.26
0.2.25
0.2.24
0.2.23
0.2.22
0.2.21
0.2.20
0.2.19
0.2.18
0.2.17
0.2.16
0.2.15
0.2.14
0.2.13
0.2.12
0.2.11
0.2.10
0.2.9
0.2.8
0.2.7
0.2.6
0.2.5
0.2.4
0.2.3
0.2.2
0.2.1
0.2.0
0.1.3
0.1.2
0.1.1-rc.20
0.1.1-rc.19
0.1.1-rc.18
0.1.1-rc.17
0.1.1-rc.16
0.1.1-rc.15
0.1.1-rc.14
0.1.1-rc.13
0.1.1-rc.12
0.1.1-rc.11
0.1.1-rc.10
0.1.1-rc.9
0.1.1-rc.8
0.1.1-rc.7
0.1.1-rc.6
0.1.1-rc.5
0.1.1-rc.4
0.1.1-rc.3
0.1.1-rc.2
0.1.1-rc.1
0.1.1-rc.0
Shared utilities for ecto-based sql data layers.
Current section
Files
Jump to
Current section
Files
README.md
<!--
SPDX-FileCopyrightText: 2020 Zach Daniel
SPDX-License-Identifier: MIT
-->
[](https://opensource.org/licenses/MIT)
[](https://hex.pm/packages/ash_sql)
[](https://hexdocs.pm/ash_sql)
[](https://api.reuse.software/info/github.com/ash-project/ash_sql)
# AshSql
Shared functionality for ecto-based sql data layers.
## Installation
```elixir
def deps do
[
{:ash_sql, "~> 0.8.0"}
]
end
```
## Aggregate Strategies
`AshSql.Implementation` defaults aggregate planning to `:lateral`. SQL data
layers can override `aggregate_strategy/1` with `:grouped` when they need the
SQLite-style grouped aggregate implementation.
The grouped strategy uses adapter-provided list aggregation. Implementations
that select `:grouped` must implement `grouped_list_aggregate/2` and return a
list expression over the `:ash_sql_grouped_aggregate_window` window. The
grouped strategy assumes SQLite-compatible SQL: list defaults are JSON-encoded,
so list values must use a JSON list representation, and offset-only query
aggregates use `LIMIT -1`. AshSQLite uses SQLite's JSON list representation
for this callback.
The aggregate facade normalizes resource aggregates and SQL aliases before
dispatch. Both strategies preserve the source binding and attachment path, so
aggregates referenced through joined relationships attach to the related row.
Alias reuse is scoped to that path and follows the existing filter/sort identity
rules. Public aggregate names, including strings, are retained in results.