What is this? Can I eat it?

A header-only library for C++26, leveraging reflections to wrap sqlite3.
Basically, it allows to leverage plain struct types as the implicit backbone for the payload on several kinds of queries, as well as their implicit or explicit returned values if using the RETURNING clause.

It offers custom specialized support for:

• INSERT (and INSERT OR REPLACE)
• DELETE
• SELECT
• UPDATE

There is no plan to implement a CREATE TABLE or CREATE VIEW, I don't want to fully replicate SQL in C++.
Otherwise one would have to handle keys, constraints, default values, multi-field keys, triggers etc, which is most likely possible, but defining some sort of new DSL on top of C++ reflections to that extent does not feel a smart move aside for its demonstrative purpose
For my application I just want to keep using proper SQL, I only really care to remove most of the boilerplate needed to run and reuse simple queries.

The library works already, but it will need a modern C++ compiler with support for reflections, and C++26 being enabled.
g++16 has it behind a flag, while clang++ only offers it in third-party branches.

It is designed to operate with exceptions disabled (but the error handling right now is very basic and should be improved.)

Not exacly the best code I ever wrote, but it was the first time trying to get something working with reflections, and there is not much material out there, so I hope it can be helpful.

Example

Check this for a basic example. Ugly code, but it covers most features which have been implemented so far.
You can see it working at compiler explorer if you don't have a compatible toolchain locally.

Licence

AGPL3.0