DuckDB: how do I use the result of a query on `DESCRIBE` to `SELECT` from a table?
Suppose I want to select all columns of a certain type from a DuckDB table. For example, selecting all VARCHAR type columns, after creating a table like:
DuckDB: how do I use the result of a query on `DESCRIBE` to `SELECT` from a table?
Suppose I want to select all columns of a certain type from a DuckDB table. For example, selecting all VARCHAR type columns, after creating a table like:
DuckDB last function does not return last value
I can’t understand why my SQL doesn’t work
Using SQL magic in Jupyter, the output only displays the header without any rows
enter image description here
DuckDB: Aggregate JSON Lists (Unique)
Is there a way to flatten a list of nested values from a json column to a list of distinct values: