Enhancement: could connection_config be typed better ? #351
Description
Summary
There is no clear mention in the docs (unless I missed it ofc) as to what exactly a user should pass to the connection_config kwarg.
so from https://sqlspec.dev/usage/drivers_and_querying.html one can infer that:
- sqlite:
{"database": str(db_path)} - asyncpg:
{"dsn": "postgresql://user:pass@localhost:5432/app"} - mysql:
{"host": "localhost", "user": "app", "password": "secret", "database": "app_db"}
etc, etc, so I feel like adding typing suport should be possible, if I want to quickly test a duckdb for instance, and I'm not that familiar to the way I should interact with the driver then sqlspec support would be awesome
Basic Example
No response
Drawbacks and Impact
No response
Unresolved questions
No response