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.

• Select AI automatically detects relevant tables and send metadata only for those specific tables, relevant to the query, in Oracle Database 23ai. You can achieve this by specifying object_list_mode as automated.

  See "Automatically Detect Relevant Table Metadata" in Example: Improve SQL Query Generation.

• Select AI enables you to restrict table access by considering only the tables listed in the AI profile attributes for SQL generation. You can achieve this by specifying enforce_object_list to true.

  See Example: Restrict Table Access in AI Profile.

• Select AI enables you to specify case sensitivity such that the LLM produces case-insensitive responses from the database and LLM. You can achieve this by specifying case_sensitive_values to false.

  See Example: Specify Case Sensitivity for Columns.

• Administrators can control data access such that actual schema tables are not sent to the LLM using Select AI.

  See ENABLE_DATA_ACCESS Procedure, DISABLE_DATA_ACCESS Procedure, and Example: Enable or Disable Data Access.