There is no arm version of Sqlserver even for arm surface and MS dropped support of arm sql edge.
docker on arm mac now support x86 images, so your best option is to run Sqlserver in a container
Run x86 docker image on Mac
https://devblogs.microsoft.com/azure-sql/development-with-sql-in-containers-on-macos/
docker pull mcr.microsoft.com/mssql/server:2022-latest
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<YourStrong@Passw0rd>" \
-p 1433:1433 --name sql2022 --hostname sql2022 \
-d \
mcr.microsoft.com/mssql/server:2022-latest
Will give emulation warning
Docker x86 support on arm Mac
https://github.com/docker/roadmap/issues/384