fun explain(analyze: Boolean = false, verbose: Boolean = false, settings: Boolean = false, buffers: Boolean = false, wal: Boolean = false, format: String = "text")

Return data as the EXPLAIN plan for the query.

Adds a filter to the postgrest request.

Return data as an object in GeoJSON format.

fun limit(count: Long, referencedTable: String? = null)

Limits the result to count rows

fun order(column: String, order: Order, nullsFirst: Boolean = false, referencedTable: String? = null)

Orders the result by column in the specified order.

fun range(range: LongRange, referencedTable: String? = null)

Limits the result to rows from range.first to range.last

fun range(from: Long, to: Long, referencedTable: String? = null)

Limits the result to rows from from to to

fun select(columns: Columns = Columns.ALL)

Return data after the query has been executed.

Return data as a single object instead of an array of objects.