The Sneller engine supports standard SQL as well as PartiQL. PartiQL makes extracting and querying JSON simple. In addition Sneller was built to deal with schema drift and large numbers of fields.
Blog: Sneller & Elastic Benchmark Results
SELECT DISTINCT repo.name FROM gharchive WHERE repo.name ILIKE '%orvalds%'
Sneller supports PartiQL which is a superset of standard SQL. This makes extracting fields from JSON trivial and makes queries simple.
SELECT COUNT FROM database where Employee_id = 3421 or Employee_id = "CA_SF_432"
Sneller easily handles schema drift where a field might change types.
"message": "this is my message",
"here": "no problem"
No mapping explosions. Sneller can handle very large numbers of JSON fields.