You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When using Session.sql there is no way (that I can find, either in the code or searching online) to properly handle parameterized SQL.
Example:
SELECT*FROM users WHERE user_id = ?;
In JDBC / PreparedStatement you can bind a value for ?, rather than resorting to the exceptionally insecure method of concatenating the value into the query directly, which is the only option Snowpark currently provides as far as I can tell.
The text was updated successfully, but these errors were encountered:
github-actionsbot
changed the title
Allow binding parameters for parameterized SQL queries
SNOW-1646794: Allow binding parameters for parameterized SQL queries
Aug 30, 2024
When using
Session.sql
there is no way (that I can find, either in the code or searching online) to properly handle parameterized SQL.Example:
In JDBC /
PreparedStatement
you can bind a value for?
, rather than resorting to the exceptionally insecure method of concatenating the value into the query directly, which is the only option Snowpark currently provides as far as I can tell.The text was updated successfully, but these errors were encountered: