Keep Fabric SQL Endpoint Up to Date

When data is updated in a Fabric Data Warehouse or Lakehouse, it's not always up to date immediately when querying the SQL Endpoint.

The same thing happens in a Fabric SQL Database but this is even more noticeable - on the SQL Database object, the data is always up to date, but on the SQL Endpoint object of the same database, the data can lag.

It is possible to refresh this as part of a pipeline by including the refresh SQL endpoint activity, but in my view the data should always be up to date through the endpoint as this can lead to discrepancies.