observablehq.com has built in support for duckdb, and I have found it to be very easy to use. Getting windowing and cte and derived columns is great and being able to just refer to sql query cells as an array of rows makes things much easier for me than breaking out into js right away.
Someone wrote an export function, so I can make a select into a table and grab that as csv to use elsewhere.
I wish for Simon Willison to adopt duckdb as he has with sqlite to see what he would create!
Someone wrote an export function, so I can make a select into a table and grab that as csv to use elsewhere.
I wish for Simon Willison to adopt duckdb as he has with sqlite to see what he would create!