Select AI enhancements

Select AI includes the following new features.

  • Select AI enables you to add table comments to the metadata of the LLM for a better SQL generation. You can achieve this by specifying comments to true in your AI profile.

    See "Example: Improve SQL Generation with Table and Column Comments" in Example: Improve SQL Query Generation.

  • Select AI integrates annotations in Oracle Database 23ai by adding it to the metadata that is sent to the LLM. You can achieve this by specifying annotations to true in your AI profile.

    See "Example: Improve SQL Query Generation with Table and Column Annotations" in Example: Improve SQL Query Generation.

  • Select AI adds foreign key and referential key constraints into the metadata of the LLM to generate accurate JOIN conditions. You can achieve this by specifying constraints to true in your AI profile.

    See "Example: Improve SQL Query Generation with Foreign Key and Referential Key Constraints" in Example: Improve SQL Query Generation.