SeaTable has an SQL-like endpoint, but not everything that is possible with mariadb or mysql will also work in SeaTable. Therefore, I would assume, that this combination of Insert and select is not supported.
Here is a summary of what is currently supported: SQL Reference - SeaTable Developer Manual
Probably @daniel.pan can correct me if I am wrong…
