GitHub user zeroshade added a comment to the discussion: Escaping identifiers for safe dynamic SQL in Python for PostgreSQL
ADBC doesn't provide a module for dynamic SQL construction, but anything which can generate the query string could be used with ADBC (just as it could with standard DBAPI functions). In the case of the `psycopg` sql module you linked to, it appears to have an `as_string()` method that could generate the full query string which could then be passed to `cur.execute(...)` with ADBC. The same would be true for things like sqlglot and so on which can generate the SQL query string for you. GitHub link: https://github.com/apache/arrow-adbc/discussions/2856#discussioncomment-13258987 ---- This is an automatically sent email for user@arrow.apache.org. To unsubscribe, please send an email to: user-unsubscr...@arrow.apache.org
