The minimum for this to be useful would be:

POST /-/update/mydb/my_table?pk=mycolumn - body is a JSON array of values

This will create the table if it doesn't exist. It will insert-replace the data based on the primary key (if one was specified).

Add ?alter=true to alter the table and add any missing columns if needed.

Originally posted by @simonw in #1 (comment)