sql-query-identifier
sql-query-identifier copied to clipboard
`SELECT INTO` statement `executionType` is `LISTING`
The following call:
const result = identify("SELECT * INTO public.\"MyTable1\" FROM public.\"MyTable2\"");
Yields the following result:
[
{
"start": 0,
"end": 53,
"text": "SELECT * INTO public.\"MyTable1\" FROM public.\"MyTable2\"",
"type": "SELECT",
"executionType": "LISTING",
"parameters": [
],
"tables": [
]
}
]
Given that SELECT INTO statements modify data, the executionType is arguably more accurately described by MODIFICATION.