SQLSyntaxSupport

Returns table name and alias name part in SQL. If alias name and table name are same, alias name will be skipped.

 sql"select ${m.result.*} from ${Member.as(m)}"

Auto session for current connection pool.

Clears column names loaded from JDBC metadata.

Returns ColumnName provider for this (expected to use for insert/update queries).

If you prefer columnNames than columns, override this method to customize.

Column names for this table (default: column names that are loaded from JDBC metadata).

Connection Pool Name. If you use NamedDB, you must override this method.

Delimiter for alias names in SQL.

True if you need forcing upper column names in SQL.

Rule to convert field names to column names.

 override val nameConverters = Map("^serviceCode$" -> "service_cd")

Schema name if exists.

Returns SQLSyntax provider for this.

 val m = Member.syntax
 sql"select ${m.result.*} from ${Member as m}".map(Member(m.resultName)).list.apply()
 // select member.id as i_on_member, member.name as n_on_member from member

Returns SQLSyntax provider for this.

 val m = Member.syntax("m")
 sql"select ${m.result.*} from ${Member as m}".map(Member(m.resultName)).list.apply()
 // select m.id as i_on_m, m.name as n_on_m from member m

scalikejdbc.interpolation.SQLSyntax value for table name.

Notice: Table name is specified with a String value which might be an input value.

Table name (default: the snake_case name from this companion object's name).

Table name with schema name.

If you need some exotic table types like MATERIALIZED VIEW from PostgreSQL, override this method.

True if you need shortening alias names in SQL.

True if you need to convert field names to snake_case column names in SQL.