How to set language globally in Synapse Analytics?

Question

Hi,

We would like to set our entire Synapse Analytics data warehouse to always interpret dates in queries using day/month/year format. By the default the language is set to US English, which implies that the dates are interpreted as month/day/year. Additionally, US English treats Sunday as the first day of the week, we would prefer Mondays. Looks like setting the language of the database to British English solves the issue, however we could not find anything about how to do it properly.

We have tried SET LANGUAGE, but it works only for the scope of current session. sp_configure is disabled for Synapse Analytics databases, similarly to ALTER LOGIN, which might be problematic anyway since it would set the language for all the existing logins, but not for the ones that will be created in the future. We deploy our data warehouse as a data tier application, but the language setting seems not to be present anywhere in the project properties in Visual Studio.

How can we set the language to British English globally once for good?
Thanks!