while the visual studio database tools were updated to support arm, there is no sqlserver support for arm processors and windows x86 emulation does not support sqlserver.
other than using a cloud hosted sqlserver, currently your only windows option is the Azure SQL Edge docker image. support for this product ends this year, and the arm version is out of support. but you can still pull the arm image. edge is based on azure sql, and somewhere between sqlserver 2019 & sqlserver 2022.
https://hub.docker.com/r/microsoft/azure-sql-edge
note: I run this on my arm Macs (M1/M4), but as Mac docker, unlike windows, supports amd64 images (via rosetta), I may switch to the SQLServer 2025 amd64 container.