On Tue, Aug 26, 2025 at 6:13 PM Mungo Gill via Boost <boost@lists.boost.org> wrote:
One thing that struck me about the 'prepare' function is the choice of placeholders. `?`-based `?1`, `?2` are used for numbered placeholders, and `$`-based `$name1`, `$name2` for named placeholders. This feels slightly inconsistent, but it matches what sqlite already does, so this point can probably also be mitigated by pointing out in the docs that the syntax is driven by sqlite3 (with appropriate link).
https://www.sqlite.org/lang_expr.html#parameters You do state that "I do not have any experience of SQLite" but remark on exposing handles and named params still are "unfair" to a wrapper library that can't (and shouldn't) change the SQL dialect of SQLite. Boost.SQLite's doc shouldn't be a rehash of the extensive SQLite docs. Anyone using that wrapper lib should have experience with SQLite. Especially with vtables indeed. Proper emulation of indexing in vtables is complicated in and of itself, even based on SQLite's doc. They could have improved since I did that on top of Boost.Multi-Index though. --DD