Looks like you need to use DuckDB.query
"""
Executes a SQL query within a connection and returns the full (materialized) result.
The query function is able to run queries with multiple statements, unlike `DBInterface.execute`(@ref) which is only able to prepare a single statement.
"""
function query(con::DuckDB.Connection, sql::AbstractString)