// things which should not be parsed.

// simplest
slect * from foo

// really simple from foo where clause
select foo from foo where name = foo
select * from foo where name' != foo
select * from foo where (name < foo
select key from foo where name & foo

// add some aggregators to the target list
select key,summer(foo) from foo

// ok, some casting. note that no parsing is done in quoted string which is being cast.
select * from foo where age = bool 'true'
select * from foo where age = (string)10
select * from foo where age = (long)'11'

// some ands
select key,value from foo where (age > 100 and zip=20144
select key,value from foo where (age > 100 and zip=20144 and time)
select key,value from foo where ((age > 100 and zip=20144 and time > 10 and fun>100)

// some ors
select key,value from foo where (age > 100 or zip=20144
select key,value from foo where (age > 100 or zip=20144 or > 10)
select key,value from foo where (age > 100 or zip=20144) or time > 10 or fun>100)

// ors and ands, partying together
select key,value from foo where (age > 100 and zip=20144) or time > 10)
select key,value from foo where ((age > 100 or zip=20144 and (time > 10 or fun>100))
select key,value from foo where ((age > 100 or zip=20144) time > 10)
select key,value from foo where ((age > 100 and zip'=20144) or (time > 10 and fun>100))

// group by?
select * from foo where ((age > 100 and zip=20144) or time > 10) groupby age 
select * from foo where ((age > 100 and zip=20144) or time > 10) group by 

// order by?
select * from foo where ((age > 100 and zip=20144) or time > 10) orderby age 
select * from foo where ((age > 100 and zip=20144) or time > 10) order by age order by 

// order and group by, mixing order
select * from foo where ((age > 100 and zip=20144) or time > 10) group age order age  

// limit must go on the end!
select * from foo where ((age > 100 and zip=20144) or time > 10) order by age group by age order by zip limit 10 group by zip 

// some quoting chicanery
select * from foo where foo='tom\'
select * from foo where foo=\'tom\foo
select * from foo where foo='tom\u04'

select * from foo where name = (date)'abcde'
select * from foo where name = (date)'12-20'

select a, b from foo where bar is not not null