Sage CRM 2022 R2 has added support for SQL Server Web Edition.
SQL Server Web edition is a low total-cost-of-ownership option for Web hosts and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large-scale Web properties.
Note: The MS SQL Server Web Edition is available only under the Microsoft Services Provider License Agreement (SPLA).
The differences between web and standard version of SQL Server 2019 are listed here: https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16
The main differences between the Web and Standard (or Enterprise) edition are the max memory and max number of cores.
We have updated the recommended hardware requirements for Sage CRM within the System Administration Guide.
We have written an article that explains our strategy around improving deployment options here: Sage CRM 2022 - Improving deployment options and driving down total system costs. - Sage CRM Hints, Tips and Tricks - Sage CRM - Sage City Community