I’ve never understood why some SQL dialects have “SELECT ... INTO table”. What’s wrong with “INSERT INTO table SELECT ...”?
Julian > On Jun 11, 2019, at 1:27 PM, Andrew O <[email protected]> wrote: > > Does / should Calcite support select into expressions? E.g. I'm using v1.19 > with queries of the style: > > select * into temporary table "#myTempResults" from (select colA > from my Table where colA = 'abc') > > but these queries fail to parse at the "into" words in the expression. (I > have a calcite connection setup with SqlDdlParserImpl) > > Assuming this isn't currently supported, is this something that is in the > scope of the default Calcite code, or something that would need to be a > custom extension? > > I do see in Schema.TableType there is an enum value of TEMPORARY_TABLE, but > I have found where us this set / used. > > Also, as additional context > - my target DB for the queries is Postgres (so supports this SQL query > directly) > - also in the future I would like to support parsing / processing Cursor > related operations (e.g. Declare Cursor, fetch next, fetch next, etc.). > Although I'm sure if / where these would belong in Calcite. > > Thanks in advance > > Andrew
