Make Insertable and Updatable interfaces for updatable view (using trigger instead of insert/update) writable

[jcassee]

As the docs say, "[...] Updatable and Insertable interfaces for tables and views that aren’t writable are now { [key: string]: never } instead of {}.

I have a view that I have made updatable by adding triggers INSTEAD OF CREATE and INSTEAD OF UPDATE. See for example this article.

Is it possible to tell Zapatos that the Insertable and Updatable interfaces should be populated?

[jawj]

Sorry for the delay.

I can see this is an important feature. It's not currently supported, but I think it should be possible without too much trouble.

I think we might need a new generate-time config option, possibly tableOptions, to sit alongside the existing columnOptions.

Then you might add something like the following to your config:

"tableOptions": {
  "myTable": {
    "insertable": true,
    "updatable": true
  }
}

(I guess we might also allow these to be false to override behaviour in the other direction).

Does this sound sensible?

[jcassee]

Yes, this sounds great!