Class SubqueryBuilder

Index

Constructors

constructor

Methods

select where join toSubquery

Constructors

constructor

new SubqueryBuilder(from: string, alias?: string): SubqueryBuilder
Parameters
- from: string
- Optionalalias: string
Returns SubqueryBuilder
- Defined in ../home/runner/work/ts-to-rls/ts-to-rls/src/subquery-builder.ts:51

Methods

select

select(columns: string | string[]): this
Specify the columns to select
Parameters
- columns: string | string[]
  Column name(s) to select
Returns this
Example
```
// Select single column
from('project_members').select('project_id')

// Select multiple columns
from('users').select(['id', 'email', 'name'])
```
- Defined in ../home/runner/work/ts-to-rls/ts-to-rls/src/subquery-builder.ts:70

where

where(condition: Condition | ConditionChain): this

Add a WHERE clause to filter subquery results

Parameters

condition: Condition | ConditionChain
The condition to filter by

Returns this

Example

// Filter by user
from('project_members')
  .select('project_id')
  .where(column('user_id').eq(auth.uid()))

// Complex condition
from('projects')
  .select('id')
  .where(
    column('status').eq('active')
      .and(column('is_public').eq(true))
  )

join

join(
    table: string,
    on: Condition | ConditionChain,
    type?: "inner" | "left" | "right" | "full",
    alias?: string,
): this
Add a JOIN clause to the subquery
Parameters
- table: string
  The table to join
- on: Condition | ConditionChain
  The join condition
- Optionaltype: "inner" | "left" | "right" | "full"
  The join type (default: 'inner')
- Optionalalias: string
  Optional alias for the joined table
Returns this
Example
```
// Simple join
from('projects', 'p')
  .select('p.id')
  .join(
    'project_members',
    column('p.id').eq('pm.project_id'),
    'inner',
    'pm'
  )
  .where(column('pm.user_id').eq(auth.uid()))

// LEFT JOIN
from('organizations', 'org')
  .select('org.id')
  .join(
    'organization_members',
    column('org.id').eq('om.organization_id'),
    'left',
    'om'
  )
```
- Defined in ../home/runner/work/ts-to-rls/ts-to-rls/src/subquery-builder.ts:145

toSubquery

toSubquery(): SubqueryDefinition
Convert to SubqueryDefinition (internal use only)

Returns SubqueryDefinition
- Defined in ../home/runner/work/ts-to-rls/ts-to-rls/src/subquery-builder.ts:175

Class SubqueryBuilder

Index

Constructors

Methods

Constructors

constructor

Parameters

Returns SubqueryBuilder

Methods

select

Parameters

Returns this

Example

where

Parameters

Returns this

Example

join

Parameters

Returns this

Example

toSubquery

Returns SubqueryDefinition

Settings

On This Page