Oliver Mannion

Results 233 comments of Oliver Mannion

Ok gotcha. That seems like a reasonable config option and doable. A PR would be welcome.

Happening because the server doesn't return `statementTypeId` which is used by the JDBC driver. See the [types defined here](https://github.com/snowflakedb/snowflake-jdbc/blob/fa58e3496809395d039ee4d8fb2cf2767997cdd4/src/main/java/net/snowflake/client/core/SFStatementType.java#L18).

The [python connector](https://github.com/snowflakedb/snowflake-connector-python/blob/539d67501cd29ed597e2e505a129e039ba08ad08/src/snowflake/connector/cursor.py#L1183) and [JDBC driver ](https://github.com/snowflakedb/snowflake-jdbc/blob/fa58e3496809395d039ee4d8fb2cf2767997cdd4/src/main/java/net/snowflake/client/core/ResultUtil.java#L403)both uses `statementTypeId` to determine if the statement is a DML statement.

Very much looking forward to this, thank you @ppkarwasz

I was also expecting this to work: ```python now_utc = datetime.now(timezone.utc) date_format = "%Y-%m-%dT%H:%M:%S.%fZ" > assert now_utc.strftime(date_format) == IsNow(format_string=date_format, tz=timezone.utc) E AssertionError: assert '2024-05-22T08:12:30.899780Z' == IsNow(approx=datetime.datetime(2024, 5, 22, 8, 35,...

That's works but I'm not using `execute` I'm using `execute_string` in my codebase to execute multiple sql statements (I simplified it for the MRE above)

Ok but I want a DictCursor and I don't really want to roll my own loop, when I could just use `execute_string` ie: I want to use ``` conn.execute_string("select 1",cursor_class=snowflake.connector.cursor.DictCursor)...

> At present with execute_string, you can only use cursor_class: SnowflakeCursor = SnowflakeCursor. Using `cursor_class=snowflake.connector.cursor.DictCursor` with `execute_string` works for me, ie: `fetchall()` on the result returns a list of dict....