Finding a Practical Analytics Format for Structured JSON Logs

Structured JSON logs are easy to produce and hard to analyze at scale. They carry useful context, but that context is nested, optional, inconsistent, and often wider than expected. Before the data can be queried comfortably, it usually has to become a table. The question is not only "can we flatten it?" The more useful question is: After flattening, what should the output be? CSV is simple and fast. Parquet is compact and portable. DuckDB gives a ready-to-query local database. SQLite is widely a