What is STRUCT? · Ultra Transcenders glossary

A SQL type that nests several named fields, where each field has a type of its own.

In the Ultra Transcenders books

Each book explains STRUCT in context, with comparison tables and the common traps.

Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
WHERE
Limits a SELECT, UPDATE or DELETE to just the rows meeting a condition. Omit it, and the statement hits every row.

failOnError
Controls how ai_query treats failures. It starts as true; change it to false and each result becomes a STRUCT containing the response and any error, letting a run survive a single bad row.
modelParameters
An ai_query argument, passed as a struct, that sets options like temperature and max_tokens. Its values have to be constants rather than depending on the data, and it requires Databricks Runtime 15.3 or later.
SEQUENCE BY
The part of an AUTO CDC definition that names the column, or a STRUCT of columns, used to put change records in order so that late or out-of-order events are applied correctly. In Python it is sequence_by.