How to query a list of Python dictionaries using DuckDB, without previously converting to another format. We can pass the list of dictionaries to the query directly and use unnest to convert to a list of rows. We can also expand the struct to multiple columns. Note: all the dictionaries must have the same keys. # /// script# requires-python = ">=3.12"# dependencies = ["duckdb"]# ///importduckdbDATA=[{"foo":1,"bar":"some string","baz":1.23},{"foo":2,"bar":"some other string","baz":2.34},{"foo"...
