Create a keyword in the SELECT statement to synchronize the ECP

InterSystems IRIS implementations that use Enterprise Cache Protocol (ECP), such as distributed cache clusters, can synchronize query results. ECP is a distributed data caching architecture that manages the distribution of data and locks among a heterogeneous network of server systems.

Imagine a scenario where the front-end calls an API to create a order and then updates a table that lists those orders. The API that registers the orders is handled by ECP1, and the table is updated via JDBC, which is handled by ECP2. If this execution is very fast, the order created in ECP1 has not yet been updated in ECP2, so the table does not show the created order.

To ensure synchronization, we can change use the option $SYSTEM.SQL.Util.SetOption("ECPSync",1,.oldval). The documentation for this option can be found here: https://docs.intersystems.com/iris20253/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_queries#GSQL_queries_ecp

But this command must be called before executing the SQL, which has two problems:
- We are calling the SQL via JDBC, we cannot execute this command.
- The command changes the configuration for all executed SQL queries, not just the query we are going to run.

So my idea is to have a keyword in the SELECT statement so that it performs the $system.ECP.Sync() for that query only, for example:

"SELECT * from ECPSync package.mytable WHERE ..."