One caveat is when you have to upgrade across major database versions. The more your application utilises these features, the more you're likely to hit when next major version upgrade has to happen.
Not that major database versions are any simpler even if you just stick to CRUD for databases.
Not that major database versions are any simpler even if you just stick to CRUD for databases.