Left lateral joins not supported by SQLite3.

[jimsynz]

Describe the bug
I tried to use a list aggregate to summarise related data and failed.

To Reproduce
See #79

Expected behavior
It should run the aggregate without error.

** Runtime

• Elixir version 1.17.3
• Erlang version 27.1
• OS macOS Sequoia
• Ash version 3.4.19
• Ash Sqlite 0.2.0

Additional context
Add any other context about the problem here.

[zachdaniel]

I didn't even realized we supported aggregates in this data layer TBH.