

Express Edition has always been free.This isn't really pertinent to your question but it is sort-of a "hidden cost" if you're not careful,SQL Server Data Platform professionals, database administrators and SQL developers can download SQL Server 2017 Developer Edition free for non-production environment use. It is important to note for SQL programmers and database professionals that SQL Server 2017 Developer Edition is full-featured free edition which can be used to learn, develop and test SQL Server If you're using Developer Edition and deploying to Standard Edition, don't accidentally try build something that's available in Developer Edition but not Standard Edition. Developer Edition is (or was, not sure if it still is) essentially Enterprise Edition, but licensed for use only in development environments. So, you could, in theory, "accidentally" build something in your dev environment that uses an "enterprise" feature that is not available in your Standard Edition target environment. Don't do that - stick with features you know are available in your eventual production target. Otherwise you may end up having to rip out the functionality (potentially expensive/time consuming), or upgrade your target to a version that has the feature you need, and that would probably get expensive.
So we should be able to download SQL Server 2016. SQL Server 2019 Express is a free edition of SQL Server, ideal for development and production for desktop, web and small server applications. Connect with user groups and data community resources related to SQL Server, Azure Data and As far as I know, there isn't something like a server level "edition compatibility mode" setting.

Sql Server Developer Edition Code Without Having
PDW is marketed as an easy to deploy and cost effective server appliance for big data. LocalDB is useful for those wishing to write and test Transact-SQL code without having to manage a full SQL Server instance.Express with Advanced Services consists of the SQL Database Engine with full text search and reporting services.The Web Edition is intended for use on public websites and is only available to third-party hosting service providers.The Parallel Data Warehouse is a pre-configured bundle, providing SQL Server 2016 and server hardware from either HP or Dell™. LocalDB copies the files necessary to start the SQL Server Database Engine, boasting all of the programming functionality, and running in user mode. The Express Edition includes only the database engine and is suited for remote connections or remote administration.LocalDB is a lightweight version of SQL Express, intended for developers.
