1foo input.sql /^CREATE TABLE foo($/;" t 2col1 input.sql /^ col1 text$/;" E table:foo 3bar input.sql /^CREATE TABLE bar AS$/;" t 4col2 input.sql /^SELECT 1 AS col2;$/;" E table:bar 5table_with_subselect input.sql /^CREATE TABLE table_with_subselect AS$/;" t 6foo input.sql /^SELECT foo,$/;" E table:table_with_subselect 7bar input.sql /^ 2 AS bar$/;" E table:table_with_subselect 8table_with_join input.sql /^CREATE TABLE table_with_join AS$/;" t 9foo input.sql /^SELECT foo,$/;" E table:table_with_join 10bar input.sql /^ a.bar,$/;" E table:table_with_join 11b_bar input.sql /^ b.bar AS b_bar$/;" E table:table_with_join 12table_with_weird_expressions input.sql /^CREATE TABLE table_with_weird_expressions AS$/;" t 13col1 input.sql /^SELECT 'string AS not_a_colname' AS col1,$/;" E table:table_with_weird_expressions 14col3 input.sql /^ 'two lines' AS col3,$/;" E table:table_with_weird_expressions 15col4 input.sql /^ 1 + (SELECT 1 AS inner_colname) AS col4$/;" E table:table_with_weird_expressions 16table_with_subselect2 input.sql /^CREATE TABLE table_with_subselect2 AS$/;" t 17foo input.sql /^SELECT foo,$/;" E table:table_with_subselect2 18bar input.sql /^ 2 AS bar$/;" E table:table_with_subselect2 19tmp_table0 input.sql /^CREATE TABLE tmp_table0 AS$/;" t 20