Can what you are describing (aside from “it is much faster, since way less rows or data leaving your database”) not be accomplished with a separate Anvil app with shared-table access to the database implementing these views or procedures, a separate app which could then be used as a dependency?
Is what you are describing different from what Uncle Bob calls “Gateways” in The Clean Architecture? I’m really just wanting to understand, as someone with only minimal dev experience outside of Anvil.