Wanted: Universal helper function for quoting and escaping string values

[amotl]

About

Use or provide a universal helper function for quoting and escaping string values in SQL.

Details

At #19 (review), @hammerhead suggested:

We can also check if there is a reusable method in SQLAlchemy, sqlalchemy-cratedb, or crate-python, which would already have sufficient test coverage. And such a method would be easier to re-use, since we will need it several times.

References

https://github.com/daq-tools/commons-codec/blob/898138eae3441b525592fa3a8dc7cded50458c43/src/commons_codec/transform/dynamodb.py#L146-L151

[amotl]

The right choice is probably not to apply quoting+escaping in userland, but to use parameter binding instead, as suggested by @seut at #34 (comment). Thank you.

[amotl]

Implemented.

• DMS/DynamoDB/MongoDB: Use SQL with parameters instead of inlining values #35
• DMS/DynamoDB: Use parameterized SQL WHERE clauses instead of inlining #36