search

fnc12 / sqlite_orm

❤️ SQLite ORM light header only library for modern C++
GNU Affero General Public License v3.0
2.29k stars 316 forks source link

user self define sql #1344

Open myhaquanwen opened 2 months ago

myhaquanwen commented 2 months ago

Hi ，I want user this sql：

with gsds_fun_g_tree_view as( select from gsds_fungroup where parent_id = 1 union all select gsds_fungroup. from gsds_fun_g_tree_view inner join gsds_fungroup on gsds_fun_g_tree_view.id=gsds_fungroup.parent_id) select * from gsds_fun_g_tree_view

can sqlite user self define sql ？？

fnc12 commented 2 months ago

hi. with is supported starting from v1.9 release which is published about a day ago. Please look through CTE example

fnc12 commented 4 weeks ago

@myhaquanwen do you have more questions?