klaus triendl

Common Table Expressions are here! It's been a long journey that spawned many other improvements and fixes.

vcpkg's “x64-uwp” triplet sets the CMake variable `CMAKE_SYSTEM_NAME=WindowsStore`, which instructs CMake to add the `/D_UNICODE` and `/DUNICODE` compiler flags. Catch2 v3 will then provide a [definition of `wmain()`](https://github.com/catchorg/Catch2/blob/4e8d92bf02f7d1c8006a0e7a5ecabd8e62d98502/src/catch2/internal/catch_main.cpp#L26) instead of...

@jimwang118 I have tested the “x64-uwp” triplet, but it would be good if you could check that too.

Thanks @jimwang118 and @RealChuan for making sure this works.

@adamski Is it a problem related to sqlite_orm?

> This doesn't run, because the quick_check has not yet been included in the amalgamated .h file which the tests rely on -- I don't see a target to build...

Hi @jakemumu It's not correct that a connection should be only single-threaded. It all depends on the requirements, and there are multiple of them as you can imagine. Your view...

Well, and honestly, your question doesn't have so much to do with sqlite_orm, but more to do with the design of your library/application and the use of SQLite3. It's hard...

@figaro-smartotum Nice to see a Rossini fan :smirk: It's not clear to me how sqlite_orm "heavily relies on double-quoted strings". sqlite_orm sets all identifiers correctly in double quotation marks and...

sqlite_orm properly [quotes and escapes](https://github.com/fnc12/sqlite_orm/blob/50cb62963b88075834eed2bce70aa18e50a0d818/dev/storage_base.h#L103) the table name.