Type: lib.supabase.Select
Namespace: lib.supabase
Description
Query records from a Supabase table. supabase, database, query, select
Properties
| Property | Type | Description | Default |
|---|---|---|---|
| table_name | str |
Table to query | `` |
| columns | record_type |
Columns to select | {'type': 'record_type', 'columns': []} |
| filters | List[Tuple[str, Enum['eq', 'ne', 'gt', 'gte', 'lt', 'lte', 'in', 'like', 'contains'], any]] |
List of typed filters to apply | - |
| order_by | str |
Column to order by | `` |
| descending | bool |
Order direction | False |
| limit | int |
Max rows to return (0 = no limit) | 0 |
| to_dataframe | bool |
Return a DataframeRef instead of list of dicts | False |
Outputs
| Output | Type | Description |
|---|---|---|
| output | any |
Metadata
Related Nodes
Browse other nodes in the lib.supabase namespace.