[SQL Database] Server-side Aggregations

[Daandamhuis]

Problem statement

Hi,

Having built several Rayfin apps by now, we're seeing a clear need for server-side support for aggregations and views, rather than handling all calculations on the client side. Many of our company's Rayfin apps combine operational CRUD functionality with real-time analytics in a single app. For the analytics piece, we currently rely on a Semantic Model to handle aggregations and a custom "service" to execute the DAX queries. This approach works for now, but it requires setting up an additional Enterprise Application just for authentication.
On top of that, some of the data in these apps originates from Azure Stream Analytics and is streamed into a table there.

Proposed solution

• Add support for creating views or direct aggregations on the server side.

Alternatives considered

• Using Direct Lake with SQL Semantic Models that already include the aggregation views we need.

Additional context