Skip to content

Implement INSERT INTO functionality

Currently Octo only supports READ access using SQL into the underlying M database. The next step would be to permit WRITE access using SQL i.e. implement the INSERT INTO functionality of SQL.

One should be able to insert

  1. One or more rows specified by value expressions OR
  2. Zero or more rows resulting from a query OR
  3. Using SELECT INTO syntax.
Edited by Narayanan Iyer