Create row level trigger for Partitioned table
I don't know about Aurora, but on recent PostgreSQL your trigger will work just fine if you define it to fire AFTER rather than BEFORE the DML operation. That should work just as well.

Triggers on partitioned tables were introduced in v11 - is upgrading an option?