I haven’t used DuckDB before, so it wasn’t my go-to; I was trying to use stuff I’ve successfully used in the past. I just took a brief look at DuckDB and it does indeed look like it may have been a good tool to use for this work. I guess I’ll try it next time!
Is there a UI (not CLI) you recommend for running queries and editing data in DuckDB?
