sqlpp11 VS mysql

sqlpp11 actually helps in this area (which imo is the most error prone area of using a database) and offers compile time query checking

I haven't used this, though I did see some presentations about it which got my interest: https://github.com/rbock/sqlpp11

If you love C++ Template magic look at https://github.com/rbock/sqlpp11

This allows "normal" C++ code, which by the compiler is converted into the query string, allowing code like

    for (const auto& row : db(select(all_of(foo)).from(foo).where(foo.hasFun or foo.name == "joker")))

Documentation: https://anarthal.github.io/mysql/index.html

For example Boost-Beast and Boost-Mysql(not officially boost) receive user provided asio::io_context and every other library in this ecosystem should be the same.

Boost.MySQL has just started review process for acceptance of boost. It's based on asio. https://github.com/anarthal/mysql

The library is at https://github.com/anarthal/mysql and the documentation is at https://anarthal.github.io/mysql/. Examples under https://anarthal.github.io/mysql/mysql/examples.html.