Recently, I’ve been interested in the DuckDB project (like a SQLite geared towards data applications). And one of the amazing features is that it has many data importers included without requiring extra dependencies. This means it can natively read and parse JSON as a database table, among many other formats.
This is really interesting and is similar to how I’ve started using steampipe to do any kind of querying/searching/reporting in aws!
I’m really liking DuckDBs approach to things.