Session/cursor specific `paramstyle`

[jmg-duarte]

What is the current behavior?

The paramstyle must be declared before opening a connection.

What is the desired behavior?

To be able to declare the paramstyle on a finer grain level.

How would this improve snowflake-connector-python?

Provide users with more flexibility to set their paramstyle without requiring different connections.

By default, the connector uses pyformat, however, in some places we want to be able to use other paramstyles, such as qmark, however this requires creating a new connection just for a single query using a different parameter.