select

fun select(where: Where<T>? = null, orderBy: List<OrderBy<T>> = emptyList(), limit: Long? = null, offset: Long? = null, expiresAfter: Instant? = null): Flow<List<T>>(source)

Select using where clause. If where is null, all rows will be selected.

Simple example with where and orderBy:

val merchantsFlow = store.select(
where = Merchant::category like "Restaurant",
orderBy = listOf(OrderBy(Merchant::createdAt, OrderDirection.DESC))
)

Note: like selectByKeys, this re-emits on every committed write to the store (one emission per transaction), even when the resulting list is unchanged — it does not distinctUntilChanged. selectResult and metadata do dedupe consecutive identical emissions; add your own .distinctUntilChanged() if you want that here.