Function from

Example

// Simple subquery - users can see projects they're members of
policy('member_projects')
  .on('projects')
  .read()
  .when(
    column('id').in(
      from('project_members')
        .select('project_id')
        .where(column('user_id').eq(auth.uid()))
    )
  );

// Subquery with alias
policy('org_projects')
  .on('projects')
  .read()
  .when(
    column('org_id').in(
      from('organizations', 'org')
        .select('org.id')
        .where(column('org.is_active').eq(true))
    )
  );

// Subquery with join
policy('accessible_docs')
  .on('documents')
  .read()
  .when(
    column('project_id').in(
      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()))
    )
  );
Copy