from
Specifies the primary table for the SELECT query.
This method continues building the SELECT statement initiated by select. It defines the source table from which data will be retrieved.
Example
// Select all columns from the Users table
select().from(Users)
// Select specific columns from the Users table
select(Users.id, Users.name).from(Users)Return
A SelectStatement object, allowing further chaining with methods like where(), join(), orderBy(), etc.
Author
MOHAMMAD AZIM ANSARI
Parameters
The primary table to select data from.
Type Parameters
The type of the primary table, which must extend KQLiteTable.
See also
Specifies the primary table for the SELECT query.
This method continues building the SELECT statement initiated by select. It defines the source table from which data will be retrieved. An optional second table can be provided to set up for a com.kqlite.table.JSON_EACH operation later in the query chain.
Example
// Select all columns from the Users table
select().from(Users)
// Select specific columns from the Users table
select(Users.id, Users.name).from(Users)
// Using second table for JSON_EACH
val json = JSON_EACH(JsonLiteral("""{"name": "Alice", "age": 30}"""))
select(Users.name, json.key, json.value)
.from(Users, json)
.execute()Return
A SelectStatement object, allowing further chaining with methods like where(), join(), orderBy(), etc.
Author
MOHAMMAD AZIM ANSARI
Parameters
The primary table to select data from.
An optional second table, typically used as the target for a subsequent join() call.
Type Parameters
The type of the primary table, which must extend KQLiteTable.