Skip to content

basice CTE in-lining

Compare
Choose a tag to compare
@stonebig stonebig released this 01 Jan 17:11
· 108 commits to master since this release

CTE transformation into SQLite acceptable instructions

  • "with x as (y) z" CTEs can be transformed :
    . in one 'inlined' select
    . or optionally in "create tmp view x as y ;z"
  • "with x(b) as (y) z" CTEs is transformed in "create tmp table x(b);insert into x y;z"