Rules for Using SELECT AS JSON - Advanced SQL Engine - Teradata Database

• The SELECT AS JSON statement composes column values into a text format JSON document. Binary formats such as BSON or UBJSON are not supported.
• You cannot specify SELECT AND CONSUME together with SELECT AS JSON to compose JSON documents.
• If you specify TOP n or ORDER BY in the SELECT statement, you must explicitly specify the sorted fields because you cannot sort by the JSON column.