async is just an ability some client libraries offer/expose which allow
you to resume execution of your application before results are returned
from the database. This is similar to async HTTP requests, "promises"
(common in modern JavaScript), or async/await (as offered in some
languages) if you're familiar with those.
It doesn't change the 1-core per query limitation on the server.
Jim