The sqlite_scanner should have a setting sqlite_debug_show_queries, the equivalnet to pg_debug_show_queries and mysql_debug_show_queries in the other duckdb database scanner extensions.
It makes sense to me to have an equivalent featureset on that front.
The implementation would be using the DuckDB printer, to print to stdout.