This feels like a custom solution, which will require some code in the database. It might work, and it might even be a good idea if the database is shared betwe

This feels like a custom solution, which will require some code in the database. It might work, and it might even be a good idea if the database is shared between many apps, but if the DB serves one app, I'd rather write code in a coding language than in (PL/)SQL.