Aurora DSQL Can it be used in production environments now

No, Aurora DSQL cannot be used in production environments at this time. It is currently available only in preview, which means it is not yet ready for production use. The preview version is intended for testing and evaluation purposes.

During the preview phase, AWS makes the service available for developers and organizations to explore its features, provide feedback, and prepare for eventual production use. However, preview services are not typically recommended for critical or production workloads.

It's important to note that Aurora DSQL is being offered at no charge during the preview period. This further indicates that it's not yet meant for production use, as AWS generally charges for production-ready services.

If you're interested in Aurora DSQL, you can access the preview in select AWS Regions (US East - N. Virginia, US East - Ohio, and US West - Oregon) to test and evaluate its capabilities. This will allow you to familiarize yourself with its features and prepare for when it becomes generally available for production use in the future.
Sources
Announcing Amazon Aurora DSQL (Preview) - AWS
Introducing Amazon Aurora DSQL | AWS Database Blog

According to the AWS Service Terms, the use of "beta", “preview”, “pre-release”, or “experimental” services in production is not recommended because:

• AWS may suspend or terminate your access to or use of any Beta Service or Beta Region at any time.
• Your Content used in the applicable Beta Service or Beta Region may be deleted or inaccessible and Your Content may not be migrated over to a generally available version of the applicable Beta Service or Beta Region.
• WITHOUT LIMITING ANY DISCLAIMERS IN THE AGREEMENT OR THE SERVICE TERMS, BETA SERVICES AND BETA REGIONS ARE NOT READY FOR GENERAL COMMERCIAL RELEASE AND MAY CONTAIN BUGS, ERRORS, DEFECTS, OR HARMFUL COMPONENTS. ACCORDINGLY, AND NOTWITHSTANDING ANYTHING TO THE CONTRARY IN THE AGREEMENT OR THESE SERVICES TERMS, AWS IS PROVIDING BETA SERVICES AND BETA REGIONS TO YOU “AS IS.