I’d imagine that one line patch will very soon get back-ported to earlier kernels, but in the meantime you could build a patched 6.9 kernel yourself if you’re up for it. Just make sure you have some kind of recovery option before installing it, I take no responsibilty 
$ git clone https://gitlab.manjaro.org/packages/core/linux69.git
$ cd linux69
$ curl -o 9999-alder_lake_ahci.patch https://git.kernel.org/pub/scm/linux/kernel/git/libata/linux.git/patch/?id=9e2f46cd87473c70d01fcaf8a559809e6d18dd50
$ sha256sum 9999-alder_lake_ahci.patch
Edit PKGBUILD, add 9999-alder_lake_ahci.patch to the end of sources, and the sum to the end of sha256sums, then run makepkg (which will take a while depending on your system - around 25 minutes on my 5800X with 32GB ram and MAKEFLAGS="-j$(nproc)" in /etc/makepkg.conf).
And when it’s all done you should have the packages
linux69-6.9.3-1-x86_64.pkg.tar.zst
linux69-headers-6.9.3-1-x86_64.pkg.tar.zst