Support for syntax not allowed as prepared statements

[paurkedal]

MariaDB/MySQL does not allow certain syntax in prepared statements, so it seems, at least for now, the mysql_query and the related async functions are needed to support the full SQL language.

I had a look at it in connection with paurkedal/ocaml-caqti#42, but if I've understood the MariaDB documentation correctly, the result processing of the non-prepared API is quite orthogonal to that of the prepared API. I suspect it would require significant refactoring or split of the result handling.

[apeschar]

MariaDB supports all syntax in prepared statements from version 10.6.2 (docs), making this issue irrelevant.

[paurkedal]

It may be too early to expect people to upgrade their database servers. At least Ubuntu 20.04 LTS and RHEL 7 and 8, which are still under support, distribute older versions.