Add execute native syntax to create or replace table, insert and bulk insert syntax

Ideas (en)
,
7
  • Add possibility to create or replace a table from a execute native stmt
    that would allow server side filtering to circumvent client (Invantive) side filtering, generating unmatched performance when for exemple a join is made between million record table tables
create or replace table mytable@container1
as
execute native 
'select ML.Id, ML.Debit, ML.credit, ML.Balance, ML.Account_id, ML.Payment_id, ML.Journal_id, ML.Partner_id, ML.Move_id, ML.Date, ML.Invoice_id, ML.Quantity, ML.Name'
|| ' from account_move_line ML'
|| ' LEFT JOIN account_move M'
|| ' ON ML.Move_id = M.Id'
|| ' where M.state LIKE ''posted'''
|| 'LIMIT 10000' 
DATACONTAINER 'container2'
  • Add possibility to Bulk insert from a execute native stmt
    that would allow to insert in bulk values and leveraging server side filtering to circumvent client (Invantive) side filtering when for exemple a join is made between million record table tables, instead of using a loop stmt as described Faster loading from execute native 
bulk insert mytable@container1
execute native
'select ML.Id, ML.Debit, ML.credit, ML.Balance, ML.Account_id, ML.Payment_id, ML.Journal_id, ML.Partner_id, ML.Move_id, ML.Date, ML.Invoice_id, ML.Quantity, ML.Name'
|| ' from account_move_line ML'
|| ' LEFT JOIN account_move M'
|| ' ON ML.Move_id = M.Id'
|| ' where M.state LIKE ''posted'''
|| 'LIMIT 10000' 
DATACONTAINER 'container2'