[Feature] Add const generics for `async function`

[mohammadfawaz]

🚀 Feature

This would be quite similar to #28666 but async function.

I don't imagine the work will be much different but making this a separate issue for organizational reasons.