Ontology SQL（本体论 SQL (Ontology SQL)）¶
:::callout{theme="neutral" title="Beta"} Ontology SQL is in the beta phase of development and some features may not be available on your enrollment. Refer to the Ontology SQL documentation for more information. :::
The Ontology SQL card allows you to write SQL queries against object sets in your analysis. Using standard SQL syntax, you can select, filter, join, and aggregate object data to produce tabular results directly in Quiver.
The Ontology SQL card accepts object sets and other Ontology SQL cards as inputs. Object set inputs are referenced in your SQL query as tables, while other Ontology SQL cards can be chained together to compose more complex queries. You can also pass scalar values such as dates, numbers, strings, and booleans as inputs to parameterize your queries.
For a complete reference of available SQL operations, refer to the Ontology SQL documentation.
The Ontology SQL card also supports AIP-powered SQL generation. You can describe the analysis you want to perform in natural language, and the card will generate a SQL query for you.
Ontology SQL results can be converted to a transform table for further manipulation and charting.
Input type¶
Object set, Ontology SQL, date, number, string, boolean
Output type¶
Ontology SQL
Usage information¶
| Functionality | Availability |
|---|---|
| Standard Quiver card | Supported |
| Transform table transform | Unsupported |
See also¶
中文翻译¶
本体论 SQL (Ontology SQL)¶
:::callout{theme="neutral" title="测试版 (Beta)"} 本体论 SQL (Ontology SQL) 目前处于 测试版 (beta) 开发阶段，部分功能可能未在你的实例中开放。更多信息请参阅 本体论 SQL (Ontology SQL) 文档。 :::
本体论 SQL (Ontology SQL) 卡片允许你在分析中对对象集 (object sets) 编写 SQL 查询。使用标准 SQL 语法，你可以选择、筛选、连接和聚合对象数据，直接在 Quiver 中生成表格化结果。
本体论 SQL (Ontology SQL) 卡片接受对象集和其他本体论 SQL 卡片作为输入。在 SQL 查询中，对象集输入被引用为表，而其他本体论 SQL 卡片可以串联组合成更复杂的查询。你还可以将标量值（如日期、数字、字符串和布尔值）作为输入传递，以实现查询的参数化。
有关可用 SQL 操作的完整参考，请参阅 本体论 SQL (Ontology SQL) 文档。
本体论 SQL (Ontology SQL) 卡片还支持基于 AIP 的 SQL 生成。你可以用自然语言描述想要执行的分析，该卡片将为你生成相应的 SQL 查询。
本体论 SQL (Ontology SQL) 的结果可以转换为转换表 (transform table)，以便进一步操作和制图。
输入类型 (Input type)¶
对象集 (Object set)、本体论 SQL (Ontology SQL)、日期 (date)、数字 (number)、字符串 (string)、布尔值 (boolean)
输出类型 (Output type)¶
本体论 SQL (Ontology SQL)
使用信息 (Usage information)¶
| 功能 (Functionality) | 可用性 (Availability) |
|---|---|
| 标准 Quiver 卡片 | 支持 (Supported) |
| 转换表转换 | 不支持 (Unsupported) |