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.
The following call:
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 INTOstatements modify data, theexecutionTypeis arguably more accurately described byMODIFICATION.