Extract Spark eventlog schema from a duckdb shell

spark_eventlog_schema.sql

create table j as select json(column0) as j from read_csv_auto('eventlog.json', delim='\0');
.mode list
.header off
.once 'schema.json'
select json_group_object(event, structure) from (select j->>'Event' as event, json_group_structure(j) as structure from j group by event);