exposed
Toggle table of contents
1.0.0-rc-1
jvm
Platform filter
jvm
Switch theme
exposed
exposed-core
org.
jetbrains.
exposed.
v1.
core
Abstract
Query
Comment
Position
FRONT
AFTER_
SELECT
BACK
Alias
alias()
all
From()
and()
And
Bit
Op
and
If
Not
Null()
and
Not()
And
Op
any
From()
append()
append
To()
Array
Column
Type
array
Literal()
array
Param()
as
Literal()
Auto
Inc
Column
Type
auto
Inc
Column
Type
Avg
avg()
Base
Case
When
Basic
Binary
Column
Type
Between
between()
Bi
Composite
Column
Binary
Column
Type
bitwise
And()
bitwise
Or()
bitwise
Xor()
Blob
Column
Type
blob
Param()
Boolean
Column
Type
Companion
boolean
Literal()
boolean
Param()
Byte
Column
Type
byte
Literal()
byte
Param()
Case
case()
Case
When
Case
When
Else
Cast
cast
To()
Character
Column
Type
Char
Column
Type
Char
Length
char
Length()
Check
Constraint
Companion
Coalesce
coalesce()
Column
Column
Diff
Companion
Column
Set
Column
Transformer
column
Transformer()
Column
Type
Column
With
Transform
Comparison
Op
Complex
Expression
Composite
Column
Composite
Sql
Logger
compound
And()
Compound
Boolean
Op
compound
Or()
Concat
concat()
Count
count()
count
Distinct()
cross
Join()
Cume
Dist
cume
Dist()
Current
Or
Following
Current
Or
Preceding
Current
Row
Window
Frame
Bound
Custom
Enumeration
Column
Type
Companion
Custom
Function
Custom
Long
Function()
Custom
Operator
Custom
String
Function()
Database
Api
Companion
Database
Config
Builder
Companion
Ddl
Aware
Decimal
Column
Type
Companion
decimal
Literal()
decimal
Param()
Dense
Rank
dense
Rank()
div()
Divide
Op
Companion
Double
Column
Type
double
Literal()
double
Param()
Entity
IDColumn
Type
Enumeration
Column
Type
Enumeration
Name
Column
Type
Companion
eq()
Eq
Op
eq
Sub
Query()
Eq
Sub
Query
Op
Exists
exists()
Experimental
Database
Migration
Api
Experimental
Keyword
Api
Explain
Query
Explain
Result
Row
Companion
exposed
Logger
Expression
Companion
Expression
Alias
Expression
With
Column
Type
Expression
With
Column
Type
Alias
Field
Set
Filter
Condition
First
Value
first
Value()
Float
Column
Type
float
Literal()
float
Param()
Foreign
Key
Constraint
full
Join()
Function
function()
get()
greater()
greater
Eq()
Greater
Eq
Op
greater
Eq
Sub
Query()
Greater
Eq
Sub
Query
Op
Greater
Op
greater
Sub
Query()
Greater
Sub
Query
Op
Group
Concat
group
Concat()
has
Flag()
IColumn
Type
IDate
Column
Type
id
Param()
IExpression
Alias
Index
in
List()
inner
Join()
in
Sub
Query()
In
Sub
Query
Op
in
Table()
Integer
Column
Type
Internal
Api
int
Literal()
int
Param()
int
To
Decimal()
is
Auto
Inc
is
Distinct
From()
Is
Distinct
From
Op
is
Not
Distinct
From()
Is
Not
Distinct
From
Op
is
Not
Null()
Is
Not
Null
Op
is
Null()
Is
Null
Op
is
Null
Or
Empty()
ISql
Expression
Builder
Join
Join
Condition
join
Query()
Join
Type
INNER
LEFT
RIGHT
FULL
CROSS
Json
Column
Marker
Key
Lag
lag()
Large
Text
Column
Type
last
Query
Alias
Last
Value
last
Value()
Lead
lead()
left
Join()
less()
less
Eq()
Less
Eq
Op
less
Eq
Sub
Query()
Less
Eq
Sub
Query
Op
Less
Op
less
Sub
Query()
Less
Sub
Query
Op
like()
Like
Escape
Op
Like
Pattern
Companion
Literal
Op
Locate
locate()
Long
Column
Type
long
Literal()
long
Param()
Lower
Case
lower
Case()
match()
Max
max()
Medium
Text
Column
Type
Min
min()
minus()
Minus
Op
mod()
Mod
Op
Companion
neq()
Neq
Op
next
Int
Val()
next
Long
Val()
Next
Val
Int
Next
Val
Long
Next
Val
No
Op
Conversion
not()
not
Eq
Sub
Query()
Not
Eq
Sub
Query
Op
Not
Exists
not
Exists()
not
In
List()
not
In
Sub
Query()
Not
In
Sub
Query
Op
not
In
Table()
not
Like()
Not
Op
Nth
Value
nth
Value()
Ntile
ntile()
Nullable
Column
With
Transform
Offset
Following
Window
Frame
Bound
Offset
Preceding
Window
Frame
Bound
Offset
Window
Frame
Bound
Op
Companion
FALSE
TRUE
or()
Or
Bit
Op
or
If
Not
Null()
or
Not()
Or
Op
Percent
Rank
percent
Rank()
plus()
Plus
Op
Query
Alias
Query
Builder
Query
Parameter
Random
Rank
rank()
Reference
Option
CASCADE
SET_
NULL
RESTRICT
NO_
ACTION
SET_
DEFAULT
regexp()
Regexp
Op
rem()
Result
Row
Companion
right
Join()
Row
Number
row
Number()
Schema
Schema
Utility
Api
Companion
Select
Sequence
Short
Column
Type
short
Literal()
short
Param()
Slf4j
Sql
Debug
Logger
Slice
slice()
Sort
Order
ASC
DESC
ASC_
NULLS_
FIRST
DESC_
NULLS_
FIRST
ASC_
NULLS_
LAST
DESC_
NULLS_
LAST
Sql
Expression
Builder
Sql
Logger
Std
Dev
Pop
std
Dev
Pop()
Std
Dev
Samp
std
Dev
Samp()
Std
Out
Sql
Logger
String
Column
Type
Companion
string
Literal()
string
Param()
Sub
Query
Op
Substring
substring()
Sum
sum()
Table
Dual
Primary
Key
target
Tables()
Text
Column
Type
times()
Times
Op
Transaction
Trim
trim()
UByte
Column
Type
ubyte
Literal()
ubyte
Param()
UInteger
Column
Type
uint
Literal()
uint
Param()
ULong
Column
Type
ulong
Literal()
ulong
Param()
Unbounded
Following
Window
Frame
Bound
Unbounded
Preceding
Window
Frame
Bound
Unbounded
Window
Frame
Bound
Upper
Case
upper
Case()
User
Data
Holder
UShort
Column
Type
ushort
Literal()
ushort
Param()
UUIDColumn
Type
Companion
Value
Case
Value
Case
When
Value
Case
When
Else
Var
Char
Column
Type
Var
Pop
var
Pop()
Var
Samp
var
Samp()
Version
Companion
Window
Frame
Bound
Companion
Window
Frame
Bound
Direction
PRECEDING
FOLLOWING
Window
Frame
Clause
Window
Frame
Unit
ROWS
RANGE
GROUPS
Window
Function
Window
Function
Definition
wrap()
wrap
As
Expression()
Xor
Bit
Op
org.
jetbrains.
exposed.
v1.
core.
dao.
id
Composite
ID
Companion
Composite
Id
Table
Entity
ID
Entity
IDFactory
Entity
IDFunction
Provider
Id
Table
Int
Id
Table
Long
Id
Table
UInt
Id
Table
ULong
Id
Table
UUIDTable
org.
jetbrains.
exposed.
v1.
core.
datetime
Duration
Column
Type
Instant
Column
Type
Local
Date
Column
Type
Local
Date
Time
Column
Type
Local
Time
Column
Type
Offset
Date
Time
Column
Type
org.
jetbrains.
exposed.
v1.
core.
functions.
array
Array
Get
Array
Slice
org.
jetbrains.
exposed.
v1.
core.
functions.
math
Abs
Function
ACos
Function
ASin
Function
ATan
Function
Ceiling
Function
Cos
Function
Cot
Function
Degrees
Function
Exp
Function
Floor
Function
Pi
Function
Power
Function
Radians
Function
Round
Function
Sign
Function
Sin
Function
Sqrt
Function
Tan
Function
org.
jetbrains.
exposed.
v1.
core.
ops
All
Any
From
Array
Op
All
Any
From
Base
Op
All
Any
From
Expression
Op
All
Any
From
Sub
Query
Op
All
Any
From
Table
Op
In
List
Or
Not
In
List
Base
Op
In
Table
Op
Multiple
In
List
Op
Pair
In
List
Op
Single
Value
In
List
Op
Triple
In
List
Op
org.
jetbrains.
exposed.
v1.
core.
statements
Batch
Data
Inconsistent
Exception
Batch
Insert
Statement
Batch
Replace
Statement
Batch
Update
Statement
Batch
Upsert
Statement
build
Statement()
Delete
Statement
Companion
expand
Args()
Global
Statement
Interceptor
Insert
Select
Statement
Insert
Statement
insert
Value()
Merge
Select
Statement
Merge
Statement
Clause
Clause
Action
INSERT
UPDATE
DELETE
DO_
NOTHING
Clause
Condition
MATCHED
NOT_
MATCHED
Merge
Table
Statement
Replace
Select
Statement
Replace
Statement
Returning
Statement
SQLServer
Batch
Insert
Statement
Statement
Statement
Builder
Statement
Context
Statement
Group
DDL
DML
Statement
Interceptor
Statement
Result
Count
Object
Statement
Type
SELECT
INSERT
UPDATE
DELETE
GRANT
CREATE
ALTER
TRUNCATE
DROP
EXEC
PRAGMA
SHOW
MULTI
OTHER
MERGE
Update
Builder
Update
Statement
Upsert
Builder
Companion
Upsert
Sql
Expression
Builder
Upsert
Statement
org.
jetbrains.
exposed.
v1.
core.
statements.
api
Exposed
Blob
Exposed
Database
Metadata
Exposed
Savepoint
Identifier
Manager
Api
Prepared
Statement
Api
Result
Api
Row
Api
org.
jetbrains.
exposed.
v1.
core.
transactions
nullable
Transaction
Scope()
Transaction
Interface
Transaction
Manager
Api
transaction
Scope()
Transaction
Store
org.
jetbrains.
exposed.
v1.
core.
utils
Cache
With
Default
Cache
With
Suspendable
Default
org.
jetbrains.
exposed.
v1.
core.
vendors
ANSI_
SQL_
2003_
KEYWORDS
Column
Metadata
current
Dialect
Database
Dialect
Companion
Data
Type
Provider
For
Update
Option
For
Update
For
Update
Base
For
Update
Or
Share
Mode
Maria
DB
Lock
In
Share
Mode
My
SQL
For
Share
Companion
For
Update
Lock
In
Share
Mode
MODE
NO_
WAIT
SKIP_
LOCKED
Oracle
For
Update
No
Wait
For
Update
Wait
Postgre
SQL
For
Key
Share
Companion
For
No
Key
Update
Companion
For
Share
Companion
For
Update
MODE
NO_
WAIT
SKIP_
LOCKED
Function
Provider
Match
Mode
H2Dialect
Companion
H2Compatibility
Mode
My
SQL
Maria
DB
SQLServer
Oracle
Postgre
SQL
H2Major
Version
One
Two
h2Mode
Maria
DBDialect
Companion
Mysql
Dialect
Companion
Oracle
Dialect
Companion
Postgre
SQLDialect
Companion
Postgre
SQLNGDialect
Companion
Primary
Key
Metadata
Schema
Metadata
SQLite
Dialect
Companion
SQLServer
Dialect
Companion
Vendor
Dialect
Dialect
Name
Provider
VENDORS_
KEYWORDS
org.
jetbrains.
exposed.
v1.
exceptions
Duplicate
Column
Exception
Exposed
SQLException
Long
Query
Exception
Unsupported
By
Dialect
Exception
exposed-crypt
org.
jetbrains.
exposed.
v1.
crypt
Algorithms
Byte
Array
Encryption
Transformer
encrypted
Binary()
Encrypted
Binary
Column
Type
encrypted
Varchar()
Encrypted
Var
Char
Column
Type
Encryptor
String
Encryption
Transformer
exposed-dao
org.
jetbrains.
exposed.
v1.
dao
alert
Subscribers()
Composite
Entity
Composite
Entity
Class
Dao
Entity
ID
Dao
Entity
IDFactory
Entity
Entity
Batch
Update
Entity
Cache
Companion
entity
Cache
Entity
Change
Entity
Change
Type
Created
Updated
Removed
Entity
Class
Entity
Field
With
Transform
Entity
Hook
Entity
Lifecycle
Interceptor
flush
Cache()
Immutable
Cached
Entity
Class
Immutable
Entity
Class
Inner
Table
Link
Int
Entity
Int
Entity
Class
load()
Long
Entity
Long
Entity
Class
Optional
Back
Reference
Optional
Reference
Reference
Referrers
register
Change()
registered
Changes()
to
Entity()
UInt
Entity
UInt
Entity
Class
ULong
Entity
ULong
Entity
Class
UUIDEntity
UUIDEntity
Class
View
with()
with
Hook()
org.
jetbrains.
exposed.
v1.
dao.
exceptions
Entity
Not
Found
Exception
exposed-java-time
org.
jetbrains.
exposed.
v1.
javatime
Current
Date
Current
Date
Time
Current
Timestamp
Current
Timestamp
Base
Current
Timestamp
With
Time
Zone
Custom
Date
Function()
Custom
Date
Time
Function()
Custom
Duration
Function()
Custom
Time
Function()
Custom
Time
Stamp
Function()
Custom
Timestamp
With
Time
Zone
Function()
Date
date()
date
Literal()
date
Param()
datetime()
date
Time
Literal()
date
Time
Param()
Day
day()
duration()
duration
Literal()
duration
Param()
Hour
hour()
Java
Duration
Column
Type
Companion
Java
Instant
Column
Type
Companion
Java
Local
Date
Column
Type
Companion
Java
Local
Date
Time
Column
Type
Companion
Java
Local
Time
Column
Type
Companion
Java
Offset
Date
Time
Column
Type
Companion
Minute
minute()
Month
month()
Second
second()
Time
time()
time
Literal()
time
Param()
timestamp()
timestamp
Literal()
timestamp
Param()
timestamp
With
Time
Zone()
timestamp
With
Time
Zone
Literal()
timestamp
With
Time
Zone
Param()
Year
year()
exposed-jdbc
org.
jetbrains.
exposed.
v1.
jdbc
and
Having()
and
Where()
batch
Insert()
batch
Replace()
batch
Upsert()
Database
Companion
Database
Connection
Auto
Registration
delete()
delete
All()
delete
Ignore
Where()
delete
Returning()
delete
Where()
empty
Sized()
Empty
Sized
Iterable
Except
except()
exists()
explain()
Explain
Blocking
Executable
Exposed
Connection
Impl
insert()
insert
And
Get
Id()
insert
Ignore()
insert
Ignore
And
Get
Id()
insert
Returning()
Intersect
intersect()
Jdbc
Transaction
Companion
Lazy
Sized
Collection
Lazy
Sized
Iterable
map
Lazy()
merge
From()
name
or
Having()
or
Where()
Query
Companion
replace()
Schema
Utils
select()
select
All()
Set
Operation
Companion
Sized
Collection
Sized
Iterable
Union
union()
Union
All
union
All()
update()
update
Returning()
upsert()
upsert
Returning()
org.
jetbrains.
exposed.
v1.
jdbc.
statements
Batch
Insert
Blocking
Executable
Batch
Update
Blocking
Executable
Batch
Upsert
Blocking
Executable
Blocking
Executable
Delete
Blocking
Executable
Insert
Blocking
Executable
Insert
Select
Blocking
Executable
Merge
Blocking
Executable
Returning
Blocking
Executable
SQLServer
Batch
Insert
Blocking
Executable
to
Executable()
Update
Blocking
Executable
Upsert
Blocking
Executable
org.
jetbrains.
exposed.
v1.
jdbc.
statements.
api
Exposed
Connection
Jdbc
Exposed
Database
Metadata
Jdbc
Prepared
Statement
Api
org.
jetbrains.
exposed.
v1.
jdbc.
statements.
jdbc
Jdbc
Connection
Impl
Jdbc
Database
Metadata
Impl
Companion
Jdbc
Prepared
Statement
Impl
Jdbc
Result
Jdbc
Savepoint
origin
org.
jetbrains.
exposed.
v1.
jdbc.
transactions
in
Top
Level
Transaction()
Jdbc
Transaction
Interface
Thread
Local
Transaction
Manager
transaction()
Transaction
Manager
Companion
transaction
Manager
org.
jetbrains.
exposed.
v1.
jdbc.
transactions.
experimental
new
Suspended
Transaction()
suspended
Transaction
Async()
with
Suspend
Transaction()
org.
jetbrains.
exposed.
v1.
jdbc.
vendors
current
Dialect
Metadata
Database
Dialect
Metadata
H2Dialect
Metadata
Maria
DBDialect
Metadata
Mysql
Dialect
Metadata
Oracle
Dialect
Metadata
Postgre
SQLDialect
Metadata
Postgre
SQLNGDialect
Metadata
SQLite
Dialect
Metadata
SQLServer
Dialect
Metadata
exposed-jodatime
org.
jetbrains.
exposed.
v1.
jodatime
Current
Date
Current
Date
Time
Custom
Date
Function()
Custom
Date
Time
Function()
Custom
Time
Function()
Custom
Timestamp
With
Time
Zone
Function()
Date
date()
date
Literal()
date
Param()
datetime()
date
Time
Literal()
date
Time
Param()
Date
Time
With
Time
Zone
Column
Type
Day
day()
Hour
hour()
Joda
Local
Date
Column
Type
Joda
Local
Date
Time
Column
Type
Joda
Local
Time
Column
Type
Minute
minute()
Month
month()
Second
second()
Time
time()
time
Literal()
time
Param()
timestamp
With
Time
Zone()
timestamp
With
Time
Zone
Literal()
timestamp
With
Time
Zone
Param()
Year
year()
exposed-json
org.
jetbrains.
exposed.
v1.
json
Contains
contains()
Exists
exists()
Extract
extract()
json()
jsonb()
Json
BColumn
Type
Json
Column
Type
exposed-kotlin-datetime
org.
jetbrains.
exposed.
v1.
datetime
Current
Date
Current
Date
Time
Current
Timestamp
Current
Timestamp
Base
Current
Timestamp
With
Time
Zone
Custom
Date
Function()
Custom
Date
Time
Function()
Custom
Duration
Function()
Custom
Time
Function()
Custom
Time
Stamp
Function()
Custom
Timestamp
With
Time
Zone
Function()
Date()
date()
date
Literal()
date
Param()
datetime()
date
Time
Literal()
date
Time
Param()
Day()
day()
duration()
duration
Literal()
duration
Param()
Hour()
hour()
Kotlin
Duration
Column
Type
Companion
Kotlin
Instant
Column
Type
Companion
Kotlin
Local
Date
Column
Type
Companion
Kotlin
Local
Date
Time
Column
Type
Companion
Kotlin
Local
Time
Column
Type
Companion
Kotlin
Offset
Date
Time
Column
Type
Companion
Minute()
minute()
Month()
month()
Second()
second()
Time()
time()
time
Literal()
time
Param()
timestamp()
timestamp
Literal()
timestamp
Param()
timestamp
With
Time
Zone()
timestamp
With
Time
Zone
Literal()
timestamp
With
Time
Zone
Param()
XCurrent
Timestamp
XCustom
Time
Stamp
Function()
XKotlin
Instant
Column
Type
Companion
x
Timestamp()
Year()
year()
Year
Internal
exposed-migration-core
org.
jetbrains.
exposed.
v1.
migration.
core
Migration
Utility
Api
exposed-migration-jdbc
org.
jetbrains.
exposed.
v1.
migration.
jdbc
Migration
Utils
exposed-migration-r2dbc
org.
jetbrains.
exposed.
v1.
migration.
r2dbc
Migration
Utils
exposed-money
org.
jetbrains.
exposed.
v1.
money
composite
Money()
Composite
Money
Column
Composite
Money
Column()
currency()
Currency
Column
Type
Companion
nullable()
exposed-r2dbc
org.
jetbrains.
exposed.
v1.
r2dbc
and
Having()
and
Where()
batch
Insert()
batch
Replace()
batch
Upsert()
delete()
delete
All()
delete
Ignore
Where()
delete
Returning()
delete
Where()
dialect
dialect
Name
empty
Sized()
Empty
Sized
Iterable
Except
except()
exists()
explain()
Explain
Suspend
Executable
Exposed
R2dbc
Exception
insert()
insert
And
Get
Id()
insert
Ignore()
insert
Ignore
And
Get
Id()
insert
Returning()
Intersect
intersect()
Lazy
Sized
Collection
Lazy
Sized
Iterable
map
Lazy()
merge
From()
name
or
Having()
or
Where()
Query
Companion
R2dbc
Database
Companion
R2dbc
Database
Config
Builder
Companion
R2dbc
Transaction
Companion
replace()
Schema
Utils
select()
select
All()
Set
Operation
Companion
Sized
Collection
Sized
Iterable
Union
union()
Union
All
union
All()
update()
update
Returning()
upsert()
upsert
Returning()
url
String
org.
jetbrains.
exposed.
v1.
r2dbc.
mappers
Array
Type
Mapper
Binary
Type
Mapper
Date
Time
My
Sql
Type
Mapper
Date
Time
Null
Type
Mapper
Date
Time
Oracle
Type
Mapper
Date
Time
Type
Mapper
Default
Type
Mapper
Exposed
Column
Type
Mapper
No
Value
Container
Postgres
Specific
Type
Mapper
Present
Value
Container
Primitive
Type
Mapper
R2dbc
Registry
Type
Mapping
Companion
R2dbc
Registry
Type
Mapping
Impl
R2dbc
Type
Mapping
Type
Mapper
Value
Container
Value
Type
Mapper
org.
jetbrains.
exposed.
v1.
r2dbc.
statements
Batch
Insert
Suspend
Executable
Batch
Update
Suspend
Executable
Batch
Upsert
Suspend
Executable
Delete
Suspend
Executable
Insert
Select
Suspend
Executable
Insert
Suspend
Executable
Merge
Suspend
Executable
R2dbc
Connection
Impl
R2dbc
Prepared
Statement
Impl
Returning
Suspend
Executable
SQLServer
Batch
Insert
Suspend
Executable
Suspend
Executable
to
Executable()
Update
Suspend
Executable
Upsert
Suspend
Executable
org.
jetbrains.
exposed.
v1.
r2dbc.
statements.
api
metadata
origin
R2dbc
Database
Metadata
Impl
Companion
R2dbc
Exposed
Connection
R2dbc
Exposed
Database
Metadata
R2dbc
Local
Metadata
Impl
Companion
R2dbc
Prepared
Statement
Api
R2dbc
Result
R2dbc
Row
R2dbc
Savepoint
rows
Count()
org.
jetbrains.
exposed.
v1.
r2dbc.
transactions
in
Top
Level
Suspend
Transaction()
R2dbc
Transaction
Interface
suspend
Transaction()
suspend
Transaction
Async()
Transaction
Manager
Companion
transaction
Manager
org.
jetbrains.
exposed.
v1.
r2dbc.
vendors
current
Dialect
Metadata
Database
Dialect
Metadata
H2Dialect
Metadata
Maria
DBDialect
Metadata
Mysql
Dialect
Metadata
Oracle
Dialect
Metadata
Postgre
SQLDialect
Metadata
SQLServer
Dialect
Metadata
exposed-spring-boot-starter
org.
jetbrains.
exposed.
v1.
spring.
boot
Database
Initializer
Companion
discover
Exposed
Tables()
Exposed
Aot
Contribution
org.
jetbrains.
exposed.
v1.
spring.
boot.
autoconfigure
Exposed
Auto
Configuration
spring-transaction
org.
jetbrains.
exposed.
v1.
spring.
transaction
Exposed
Spring
Transaction
Attribute
Source
Spring
Transaction
Manager
exposed-core
/
org.jetbrains.exposed.v1.core.statements
/
MergeStatement
/
Clause
/
deleteWhere
delete
Where
val
deleteWhere
:
Op
<
Boolean
>
?
=
null
deleteWhere is applicable only to Oracle SQL database which has no dedicated "when delete" clause