Improve duckdb as a foreign table

[adsharma]

After #271, a few rough edges remain. This is a parent task with details in sub tasks

[aheev]

we need to update documentation on duckDB support. It doesn't mention we can query duckdb tables natively for instance