2024r1 Using GI's in Code Customisations (Instead of SQL View)

Over here in Australia, Acumatica goes under the brand of MYOB Advanced. As a developer we’ve been told that MYOB are wanting to remove support for SQL Views in lieu of the new features in 2024r1 whereby GI’s can now use other GI’s as input tables. This is very useful and will go a long way to removing the need for SQL Views however…

I have multiple (reasonably compex) SQL Views with corresponding DAC’s and several sub-tables. I then use the result to display data on the sales order screen. Similar to:

[PXUIField(DisplayName="Auto Build Available", Enabled = false)]
        [PXDBScalar(typeof(Search<AutoKitAssembly.KitAssy.qtyAvail,
            Where<AutoKitAssembly.KitAssy.builtItemID, Equal<SOLine.inventoryID>,
                And<AutoKitAssembly.KitAssy.siteId, Equal<SOLine.siteID>>>>))]

Where ‘AutoKitAssembly.KitAssy.qtyAvail’ is a field from a SQL View or custom table. I can now re-create the complex SQL View using the new and improved 2024 GI’s however how do I reference this GI table from within my SOExt?

Note it is not possible to convert the SQL View to a Projection DAC in BQL due to the table nesting and I dont like BQL at all..