Firedac and sqlite instead of triggers

SQLite offers a very explicit row count definition for various scenarios on the usual Create Update Delete functions. When you get fancy with 2 statements together in a Firedac update, or you use an instead of trigger the expected row count is not met and firedac throws an exception.

Is there any way to turn that off? It means firedac wont accept anything but the simplest table operations if it cannot be suppressed. I looked pretty hard for it but I couldnt find anything that would do it.

In Delphi I am using the TADQuery component with a TADUpdateSql component plugged into it. I wrote the SQL myself. It executes fine but throws exceptions.

I have a few 1:1 tables that I want to keep synced. It is the usual pseudo-inheritance/polymorphism stuff. Doing it in an instead-of clause for a view makes the separation of concerns as clean as possible.

Thanks