user self define sql

[myhaquanwen]

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]

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

[fnc12]

@myhaquanwen do you have more questions?

[fnc12]

closing due to inactivity. Feel free to reopen once you have updates