To use the SQL assistance features:
You can select from a list of SQL keywords that are appropriate for the statement, given the current position of the text cursor.
You can select from a list of SQL templates that are appropriate for the given type of SQL statement.
You can select from a list of columns that are in a table. The list can appear for column annotations, as well as for SQL statements.
You can select from a list of primary-key columns that are in a table. The list can appear for column annotations, as well as for SQL statements.
You can select from a list of schemas in the database that is associated with your Java project. The list can appear for table annotations, as well as for SQL statements.
You can select from a list of tables that are in the database that is associated with your Java project. The list can appear for table annotations, as well as for SQL statements.
You can select from a list of properties that are defined in a bean.