FYI, to mimic a batch job operation, I wanted to use Trino to run the SQL Update queries. However, the Trino PostgreSQL connector does not provide support for UPDATE SQL Statements at this moment (work is going on in the community)
Hence, I settled down on using SQLAlchmy ORM for updating tables (applying toll and pollution fees on vehicles). This is enough for us to get our job done at this moment.
FYI, to mimic a batch job operation, I wanted to use Trino to run the SQL Update queries. However, the Trino PostgreSQL connector does not provide support for UPDATE SQL Statements at this moment (work is going on in the community)
Hence, I settled down on using SQLAlchmy ORM for updating tables (applying toll and pollution fees on vehicles). This is enough for us to get our job done at this moment.