jOOQ 3.18.7 · org.jooq.util.sqlite.SQLiteDSL

Access	Constructor and Description
protected	SQLiteDSL() No instances

Method Summary

Modifier and Type	Method and Description
public static Field<Long>	rowid() Deprecated as a consequence of `Field` being deprecated. Retrieve the SQLite-specific `_rowid_` pseudo-field.

Inherited from org.jooq.impl.DSL:: abs abs acos acos acosh acosh acoth acoth aggregate aggregate aggregate aggregate aggregateDistinct aggregateDistinct aggregateDistinct aggregateDistinct all all all all alterDatabase alterDatabase alterDatabase alterDatabaseIfExists alterDatabaseIfExists alterDatabaseIfExists alterDomain alterDomain alterDomain alterDomainIfExists alterDomainIfExists alterDomainIfExists alterIndex alterIndex alterIndex alterIndexIfExists alterIndexIfExists alterIndexIfExists alterSchema alterSchema alterSchema alterSchemaIfExists alterSchemaIfExists alterSchemaIfExists alterSequence alterSequence alterSequence alterSequenceIfExists alterSequenceIfExists alterSequenceIfExists alterTable alterTable alterTable alterTableIfExists alterTableIfExists alterTableIfExists alterType alterType alterView alterView alterView alterView alterView alterViewIfExists alterViewIfExists alterViewIfExists and and and any any any any anyValue array array array array arrayAgg arrayAggDistinct arrayAppend arrayAppend arrayAppend arrayAppend arrayConcat arrayConcat arrayConcat arrayConcat arrayGet arrayGet arrayOverlap arrayOverlap arrayOverlap arrayOverlap arrayPrepend arrayPrepend arrayPrepend arrayPrepend arrayRemove arrayRemove arrayRemove arrayRemove arrayReplace arrayReplace ascii ascii asin asin asinh asinh asterisk atan atan atan2 atan2 atan2 atan2 atanh atanh avg avgDistinct begin begin bitAnd bitAnd bitAnd bitAnd bitAndAgg bitCount bitCount bitGet bitGet bitLength bitLength bitNand bitNand bitNand bitNand bitNandAgg bitNor bitNor bitNor bitNor bitNorAgg bitNot bitNot bitOr bitOr bitOr bitOr bitOrAgg bitSet bitSet bitSet bitSet bitSet bitSet bitXNor bitXNor bitXNor bitXNor bitXNorAgg bitXor bitXor bitXor bitXor bitXorAgg boolAnd boolAnd boolOr boolOr cardinality case_case_case_cast cast cast cast cast cast castNull castNull castNull catalog catalog ceil ceil century century century characterSet characterSet charLength charLength check choose choose choose choose choose choose choose chr chr coalesce coalesce coalesce coerce coerce coerce coerce coerce coerce collation collation comment commentOnColumn commentOnColumn commentOnColumn commentOnTable commentOnTable commentOnTable commentOnView commentOnView commentOnView commit concat concat concat concat condition condition condition condition condition condition condition condition condition condition condition constraint constraint constraint corr cos cos cosh cosh cot cot coth coth count count count count countDistinct countDistinct countDistinct countDistinct covarPop covarSamp createDatabase createDatabase createDatabase createDatabaseIfNotExists createDatabaseIfNotExists createDatabaseIfNotExists createDomain createDomain createDomain createDomainIfNotExists createDomainIfNotExists createDomainIfNotExists createGlobalTemporaryTable createGlobalTemporaryTable createGlobalTemporaryTable createGlobalTemporaryTableIfNotExists createGlobalTemporaryTableIfNotExists createGlobalTemporaryTableIfNotExists createIndex createIndex createIndex createIndex createIndexIfNotExists createIndexIfNotExists createIndexIfNotExists createIndexIfNotExists createOrReplaceView createOrReplaceView createOrReplaceView createOrReplaceView createOrReplaceView createOrReplaceView createSchema createSchema createSchema createSchemaIfNotExists createSchemaIfNotExists createSchemaIfNotExists createSequence createSequence createSequence createSequenceIfNotExists createSequenceIfNotExists createSequenceIfNotExists createTable createTable createTable createTableIfNotExists createTableIfNotExists createTableIfNotExists createTemporaryTable createTemporaryTable createTemporaryTable createTemporaryTableIfNotExists createTemporaryTableIfNotExists createTemporaryTableIfNotExists createType createType createUniqueIndex createUniqueIndex createUniqueIndex createUniqueIndex createUniqueIndexIfNotExists createUniqueIndexIfNotExists createUniqueIndexIfNotExists createUniqueIndexIfNotExists createView createView createView createView createView createView createViewIfNotExists createViewIfNotExists createViewIfNotExists createViewIfNotExists createViewIfNotExists createViewIfNotExists cube cube cumeDist cumeDist cumeDist currentCatalog currentDate currentInstant currentLocalDate currentLocalDateTime currentLocalDateTime currentLocalDateTime currentLocalTime currentOffsetDateTime currentOffsetTime currentSchema currentTime currentTimestamp currentTimestamp currentTimestamp currentUser date date date dateAdd dateAdd dateAdd dateAdd dateAdd dateAdd dateAdd dateAdd dateDiff dateDiff dateDiff dateDiff dateDiff dateDiff dateDiff dateDiff dateSub dateSub dateSub dateSub dateSub dateSub dateSub dateSub day day day dayOfWeek dayOfWeek dayOfWeek dayOfYear dayOfYear dayOfYear decade decade decade decode decode decode decode decode default_default_default_default_defaultValue defaultValue defaultValue defaultValue deg deg delete deleteFrom denseRank denseRank denseRank digits digits domain domain dropDatabase dropDatabase dropDatabase dropDatabaseIfExists dropDatabaseIfExists dropDatabaseIfExists dropDomain dropDomain dropDomain dropDomainIfExists dropDomainIfExists dropDomainIfExists dropIndex dropIndex dropIndex dropIndexIfExists dropIndexIfExists dropIndexIfExists dropSchema dropSchema dropSchema dropSchemaIfExists dropSchemaIfExists dropSchemaIfExists dropSequence dropSequence dropSequence dropSequenceIfExists dropSequenceIfExists dropSequenceIfExists dropTable dropTable dropTable dropTableIfExists dropTableIfExists dropTableIfExists dropTemporaryTable dropTemporaryTable dropTemporaryTable dropTemporaryTableIfExists dropTemporaryTableIfExists dropTemporaryTableIfExists dropType dropType dropType dropType dropType dropTypeIfExists dropTypeIfExists dropTypeIfExists dropTypeIfExists dropTypeIfExists dropView dropView dropView dropViewIfExists dropViewIfExists dropViewIfExists dual e emptyGroupingSet epoch epoch epoch escape escape every every excluded exists exp exp extract extract extract falseCondition field field field field field field field field field field field field field field field field field field field field field finalTable finalTable finalTable firstValue floor floor foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey foreignKey function function function function generateSeries generateSeries generateSeries generateSeries generateSeries generateSeries generateSeries generateSeries generateSeries generateSeries generateSeries generateSeries getDataType grant grant grant greatest greatest groupConcat groupConcat groupConcatDistinct grouping groupingSets groupingSets groupingSets groupsBetweenCurrentRow groupsBetweenFollowing groupsBetweenPreceding groupsBetweenUnboundedFollowing groupsBetweenUnboundedPreceding groupsCurrentRow groupsFollowing groupsPreceding groupsUnboundedFollowing groupsUnboundedPreceding hour hour hour if_if_if_if_ifnull ifnull ifnull ifnull iif iif iif iif in in index inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inline inlined inlined inlined inOut inOut insert insert insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto insertInto instant instant instant isnull isnull isnull isnull isoDayOfWeek isoDayOfWeek isoDayOfWeek jsonArray jsonArray jsonArrayAgg jsonArrayAggDistinct jsonbArray jsonbArray jsonbArrayAgg jsonbArrayAggDistinct jsonbExists jsonbExists jsonbGetAttribute jsonbGetAttribute jsonbGetAttribute jsonbGetAttribute jsonbGetAttributeAsText jsonbGetAttributeAsText jsonbGetAttributeAsText jsonbGetAttributeAsText jsonbGetElement jsonbGetElement jsonbGetElement jsonbGetElement jsonbGetElementAsText jsonbGetElementAsText jsonbGetElementAsText jsonbGetElementAsText jsonbInsert jsonbInsert jsonbInsert jsonbInsert jsonbKeys jsonbKeys jsonbObject jsonbObject jsonbObject jsonbObject jsonbObject jsonbObject jsonbObject jsonbObjectAgg jsonbObjectAgg jsonbObjectAgg jsonbObjectAgg jsonbRemove jsonbRemove jsonbReplace jsonbReplace jsonbReplace jsonbReplace jsonbSet jsonbSet jsonbSet jsonbSet jsonbTable jsonbTable jsonbValue jsonbValue jsonEntry jsonEntry jsonEntry jsonEntry jsonEntry jsonEntry jsonEntry jsonExists jsonExists jsonGetAttribute jsonGetAttribute jsonGetAttribute jsonGetAttribute jsonGetAttributeAsText jsonGetAttributeAsText jsonGetAttributeAsText jsonGetAttributeAsText jsonGetElement jsonGetElement jsonGetElement jsonGetElement jsonGetElementAsText jsonGetElementAsText jsonGetElementAsText jsonGetElementAsText jsonInsert jsonInsert jsonInsert jsonInsert jsonKeys jsonKeys jsonObject jsonObject jsonObject jsonObject jsonObject jsonObject jsonObject jsonObjectAgg jsonObjectAgg jsonObjectAgg jsonObjectAgg jsonRemove jsonRemove jsonReplace jsonReplace jsonReplace jsonReplace jsonSet jsonSet jsonSet jsonSet jsonTable jsonTable jsonValue jsonValue key key keyword lag lag lag lag lag lag lag lastValue lateral lead lead lead lead lead lead lead least least left left left left length length list list listAgg listAgg listAggDistinct listAggDistinct ln ln localDate localDate localDate localDateAdd localDateAdd localDateAdd localDateAdd localDateAdd localDateAdd localDateAdd localDateAdd localDateDiff localDateDiff localDateDiff localDateDiff localDateDiff localDateDiff localDateDiff localDateDiff localDateSub localDateSub localDateSub localDateSub localDateSub localDateSub localDateTime localDateTime localDateTime localDateTimeAdd localDateTimeAdd localDateTimeAdd localDateTimeAdd localDateTimeAdd localDateTimeAdd localDateTimeAdd localDateTimeAdd localDateTimeDiff localDateTimeDiff localDateTimeDiff localDateTimeDiff localDateTimeDiff localDateTimeDiff localDateTimeDiff localDateTimeDiff localDateTimeSub localDateTimeSub localDateTimeSub localDateTimeSub localDateTimeSub localDateTimeSub localTime localTime localTime log log log log log10 log10 lower lower lpad lpad lpad lpad lpad lpad lpad ltrim ltrim ltrim ltrim ltrim ltrim max maxDistinct md5 md5 median mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto mergeInto microsecond microsecond microsecond mid mid mid mid mid mid millennium millennium millennium millisecond millisecond millisecond min minDistinct minus minute minute minute mode mode month month month multiset multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAgg multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct multisetAggDistinct name name name name neg newTable newTable newTable noCondition noField noField noField noField not not notExists notUnique now now nthValue nthValue ntile ntile nullCondition nullif nullif nullif nullif nullSafe nullSafe nullSafe nullSafe nullSafeDataType nullSafeList nullSafeList nvl nvl nvl nvl nvl2 nvl2 nvl2 nvl2 octetLength octetLength offsetDateTime offsetDateTime offsetDateTime offsetTime offsetTime offsetTime oldTable oldTable oldTable one or or or orderBy orderBy orderBy out out overlay overlay overlay overlay param param param param param param param param param partitionBy partitionBy percentileCont percentileCont percentileDisc percentileDisc percentRank percentRank percentRank pi position position position position position position position position position position position position power power power power primaryKey primaryKey primaryKey primaryKey privilege product productDistinct quarter quarter quarter queries queries query query query query quotedName quotedName quotedName rad rad rand rangeBetweenCurrentRow rangeBetweenFollowing rangeBetweenPreceding rangeBetweenUnboundedFollowing rangeBetweenUnboundedPreceding rangeCurrentRow rangeFollowing rangePreceding rangeUnboundedFollowing rangeUnboundedPreceding rank rank rank ratioToReport ratioToReport raw recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType recordType regexpReplaceAll regexpReplaceAll regexpReplaceFirst regexpReplaceFirst regrAvgX regrAvgY regrCount regrIntercept regrR2 regrSlope regrSXX regrSXY regrSYY releaseSavepoint releaseSavepoint repeat repeat repeat repeat replace replace replace replace replace replace resultQuery resultQuery resultQuery resultQuery reverse reverse revoke revoke revoke revokeGrantOptionFor revokeGrantOptionFor revokeGrantOptionFor right right right right role role rollback rollup rollup round round round round round round row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row row rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowField rowNumber rowsBetweenCurrentRow rowsBetweenFollowing rowsBetweenPreceding rowsBetweenUnboundedFollowing rowsBetweenUnboundedPreceding rowsCurrentRow rowsFollowing rowsFrom rowsPreceding rowsUnboundedFollowing rowsUnboundedPreceding rpad rpad rpad rpad rpad rpad rpad rtrim rtrim rtrim rtrim rtrim rtrim savepoint savepoint schema schema second second second select select select select select select select select select select select select select select select select select select select select select select select select selectCount selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectDistinct selectFrom selectFrom selectFrom selectFrom selectFrom selectFrom selectOne selectZero sequence sequence sequence sequence sequence sequence set set setCatalog setCatalog setCatalog setLocal setLocal setSchema setSchema setSchema shl shl shl shl shr shr shr shr sign sign sin sin sinh sinh space space splitPart splitPart splitPart splitPart sql sql sql sqrt sqrt square square startTransaction stddevPop stddevSamp substring substring substring substring substring substring substringIndex substringIndex substringIndex substringIndex sum sumDistinct systemName systemName systemName table table table table table table table table table table table table table tan tan tanh tanh tau time time time timestamp timestamp timestamp timestampAdd timestampAdd timestampAdd timestampAdd timestampAdd timestampAdd timestampAdd timestampAdd timestampDiff timestampDiff timestampDiff timestampDiff timestampDiff timestampDiff timestampDiff timestampDiff timestampSub timestampSub timestampSub timestampSub timestampSub timestampSub timezone timezone timezone timezoneHour timezoneHour timezoneHour timezoneMinute timezoneMinute timezoneMinute toChar toChar toChar toChar toChar toChar toDate toDate toDate toDate toHex toHex toLocalDate toLocalDate toLocalDate toLocalDate toLocalDateTime toLocalDateTime toLocalDateTime toLocalDateTime toTimestamp toTimestamp toTimestamp toTimestamp translate translate translate translate trim trim trim trim trim trim trueCondition trunc trunc trunc trunc trunc trunc trunc trunc trunc trunc trunc trunc trunc trunc trunc truncate truncate truncate truncateTable truncateTable truncateTable two unique unique unique unique unique unnest unnest unnest unquotedName unquotedName unquotedName update upper upper user user using using using using using using using using using using using using using using using using using using using using uuid val val val val val val val val val val val val val val val val val val val val val val val val val val val val val val val val val val val val val val val value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value value values values values values values values values values values values values values values values values values values values values values values values values varPop varSamp week week week when when when when when when widthBucket widthBucket with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with with withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive withRecursive xmlagg xmlattributes xmlattributes xmlcomment xmlcomment xmlconcat xmlconcat xmlelement xmlelement xmlelement xmlelement xmlelement xmlelement xmlelement xmlelement xmlexists xmlexists xmlforest xmlforest xmlparseContent xmlparseContent xmlparseDocument xmlparseDocument xmlpi xmlpi xmlpi xmlpi xmlquery xmlquery xmlserializeContent xmlserializeContent xmlserializeDocument xmlserializeDocument xmltable xmltable xor xor xor year year year zero

public Class SQLiteDSL

Constructor Summary

Method Summary