Automatic Custom Level schema execution during build deployment

We wanted to have Custom schema level changes be automatically executed in the database for update build when the build is deployed in the store.

The ClientSchma.sql file is responsible for custom database schema level configurations.

Currently, we can see automatic query execution for upgrade and install build during deployment.

Let us know how it can be configured for clientschema.sql to execute automatically in DB for update build deployment.

Or if not let us know if there is any other techniques other than manual exeecution in the database.

Thanks