I think it can. If we were a few years earlier I would say: no. But now with databricks sql (or other software like Trino etc) and delta lake, I don't see why it would not work.

As we speak I am looking into getting rid of your Azure Synapse database, and I think we can pull that of without issues.

The main attention point however is to not forget to look at what tools are being used to consume data.

Because from a technical point of view, this is quickly overlooked. f.e. if your company uses some paginated reporting software, you better make sure that will still work.