[mrtimo]

DuckDB can read JSON - you can query JSON with normal SQL.[1] I prefer to Malloy Data language for querying as it is 10x simpler than SQL.[2]

[1] - https://duckdb.org/docs/stable/data/json/overview [2] - https://www.malloydata.dev/

[zie]

So can postgres, I tend to just use PG, since I have instances running basically everywhere, even locally, but duckdb works well too.