civisanalytics / civis-python

Civis API Python Client
BSD 3-Clause "New" or "Revised" License
34 stars 26 forks source link

[CIVIS-8695] ENH SQL I/O functions accept SQL parameters and arguments #493

Closed jacksonlee-civis closed 3 months ago

jacksonlee-civis commented 3 months ago

This pull request adds a new feature to the civis.io.* functions that call client.scripts.post_sql under the hood, for passing in SQL parameters and arguments. This new feature lets the user take advantage of Civis Platform's parameterized SQL scripts with functionality to mitigate security risks of SQL injections. See the linked internal ticket for testing this new feature.

Also going to make a new release of v2.3.0 after this pull request, so I'm bundling in here a few small fixes as well -- they're noted both in the changelog and comments on this PR.