CakePHP 4 and using SQL Materialized views in PostGreSQL

Not sure if it will help, but many times I use the PDO instance directly for certain queries, see Need help to create Reports