As of Apr 27 2022, you don't need custom parsing code anymore, you can set a flag to get native JSON returned! https://aws.amazon.com/about-aws/whats-new/2022/04/amazon-rds-data-api-sql-json-string/