Create or replace table dummy@inmemorystorage from execute native

[forums]

There is an existing for this on:

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

To increase performance, these options would increase high volume processing performance by replacing a loop with execute native by a real bulk insert: [bulk] insert TABLENAME() 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 'Vega' and …

The idea will be discussed in the course of this week for viability and then updated.