JSON Constructors - Actian Data Platform

Skip to content

📄 New documentation experience: the Actian Data Platform docs have moved from Adobe FrameMaker to Markdown. If anything looks off, let us know.

Actian Data Platform

JSON Constructors

Home
Tutorials
Warehouse
Data Loading
Connectivity Guide
Security Guide
SQL Language
Data Quality
Integrations

Actian Data Platform

Home
Tutorials
Warehouse
Data Loading
Connectivity Guide
Security Guide
SQL Language
SQL Language
- Introducing SQL
  Introducing SQL
- SQL Data Types
  SQL Data Types
- Elements of SQL Statements
  Elements of SQL Statements
- Embedded SQL
  Embedded SQL
- Working with Transactions and Handling Errors
  Working with Transactions and Handling Errors
- Database Procedures, Sessions, and Events
  Database Procedures, Sessions, and Events
- Working with JSON Data
  Working with JSON Data
  - Working with JSON Data
  - Data Types
  - JSON Concepts
  - JSON Constructors
    JSON Constructors
    
    JSON Constructors JSON Constructors
    On this page
    
    JSON Constructors
    
    JSON_OBJECT
    
    JSON_OBJECTAGG
    
    JSON_ARRAY
    
    JSON_ARRAYAGG
    
    How JSON Dates Are Handled
  - JSON Query Functions
  - Use of Operators with JSON Data
  - JSON Item Methods
- SQL Statements
  SQL Statements
- Actian SQL CLI
  Actian SQL CLI
- System Catalogs
  System Catalogs
- Keywords
  Keywords
- Environment Variables
  Environment Variables
Data Quality
Integrations

On this page

JSON Constructors

Home
SQL Language
Working with JSON Data
JSON Constructors

JSON Constructors¶

JSON SQL constructors generate JSON objects from table rows.

Was this page helpful?

Thanks for your feedback!

Thanks for your feedback!

JSON Predicates

Copyright © 2026, Actian

Made with Zensical