Currently, as of Babelfish 1.2.1 (May 2022), Babelfish does not support most of SQL Server's XML functions. Babelfish is always adding new capabilities, so be sure to check back frequently.
You may wish to speak to your Amazon AWS Solutions Architect for guidance. In some cases, sample code that could assist in processing XML can be provided.
Many customers work around this limitations using a number of strategies.
- They write their own in-database functions to do the XML processing.
- They shred the XML client-side, ex: using .NET.
- They remove XML and instead use JSON or another type, which Babelfish 1.2.0+ has support for.
For a full list of what's supported, see differences between Babelfish and SQL Server in the AWS Docs.
How to find workaround for xml.value() function in babelfish?Accepted Answerasked 7 months ago
Storing XML data in AWS DBasked 8 months ago
XML database in AWSasked 6 months ago
XML interpret one struct as an arrayAccepted Answerasked a year ago
FHIR Works xml type exampleasked 6 months ago
Does Aurora Babelfish support Aurora Serverless?Accepted Answer
Does Babelfish support table partitioning via CREATE PARTITION?Accepted Answer
Tag request for Babelfish
Does Babelfish support XML? How can I use XML?
Babelfish: How do I get started?Accepted Answer