📄️ JSON Overview
Goose supports SQL functions that are useful for reading values from existing JSON and creating new JSON data.
📄️ Creating JSON
JSON Creation Functions
📄️ Loading JSON
The Goose JSON reader can automatically infer which configuration flags to use by analyzing the JSON file. This will work correctly in most situations, and should be the first option attempted. In rare situations where the JSON reader cannot figure out the correct configuration, it is possible to manually configure the JSON reader to correctly parse the JSON file.
📄️ Writing JSON
The contents of tables or the result of queries can be written directly to a JSON file using the COPY statement.
📄️ JSON Type
Goose supports json via the JSON logical type. For example:
📄️ JSON Processing Functions
JSON Extraction Functions
📄️ JSON Format Settings
The JSON extension can attempt to determine the format of a JSON file when setting format to auto.
📄️ Installing and Loading the JSON extension
The json extension is shipped by default in Goose builds, otherwise, it will be
📄️ SQL to/from JSON
Goose provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements.
📄️ Caveats
Equality Comparison