`connection_view` does not work correctly for duckdb

[dfalbel]

First reported in posit-dev/positron#6517 (comment)
The issue is caused by a problem in the query generated by connections.