SETTINGS clause

[Net-Mist]

Hello,
Thanks a lot for this great project. I'm using it on a daily basis and works very well.
I was wondering if it could be interesting to add a new clause for the SETTINGS. As far as I know it is not provided by sqlalchemy. If yes, I can try to create a pull request for this.
Thanks a lot

[xzkostyan]

Hi.

You can pass settings to .execution_options() for native and asynch: https://clickhouse-sqlalchemy.readthedocs.io/en/latest/features.html#execution-options. This is more flexible than emitting SETTING clause.

[Net-Mist]

Sadly, I'm forced to use the http driver

[Net-Mist]

Do you think we could extend the execution_options function so it also works for the http driver ?