Mirror async/sync documentation from AlloyDB

Add section on Async/Sync usage similar to https://github.com/googleapis/langchain-google-alloydb-pg-python/pull/287