🔨 New mariadb-connector-cpp shortcomings (tracker)

[zach2good]

I affirm:

• I understand that if I do not agree to the following points by completing the checkboxes my issue will be ignored.
• I have read and understood the Contributing Guide and the Code of Conduct.
• I have searched existing issues to see if the issue has already been opened, and I have checked the commit log to see if the issue has been resolved since my server was last updated.

Describe the feature

#4601 introduces a new SQL connector that solves A LOT of problems, but the implementation isn't complete: https://github.com/mariadb-corporation/mariadb-connector-cpp

What this means is that we'll (I) will have to continue to use the old connector in these areas, come up with workarounds, or implement the missing logic in the cpp connector and rebuild the libs.

• SetTimeout appears to be missing
• RowsModified / RowsInserted etc. don't appear to be implemented.
• 🐛 db::encodeToBlob doesn't work with db::preparedStmt #5329
• (Unknown) charset/encoding checking
• (For LSB) Allowing query to take Args... args
• (Unknown, but assumed good) Transactions
• (Unknown) SQL internal profiling