SQL Server does not support ARM, so that is not a good start. But I believe it is possible if you run in a Docker container. I don't use Macs myself, but here is a link to an old thread: https://learn.microsoft.com/en-us/answers/questions/1298316/sql-server-2022-database-engine-services-failde?comment=answer-1266245&page=2#answers. Read the answer from Randolph West and then continue to their blog.
Here is also a link to a YouTube video: https://www.youtube.com/watch?v=9c7Ti2OcLZg