Add a simple CTE with a base query
Optional
cte.add('active_users', { model: User, baseCase: { where: { active: true } } })cte.add('active_users', { model: 'users', baseCase: { where: { active: true } } }) Copy
cte.add('active_users', { model: User, baseCase: { where: { active: true } } })cte.add('active_users', { model: 'users', baseCase: { where: { active: true } } })
Add a recursive CTE for hierarchical data
cte.addRecursive({ name: 'org_chart', model: Employee, anchor: { where: { managerId: null } }, recursive: { where: { '$org_chart.id$': { [Op.eq]: { [Op.col]: 'Employee.managerId' } } } }}) Copy
cte.addRecursive({ name: 'org_chart', model: Employee, anchor: { where: { managerId: null } }, recursive: { where: { '$org_chart.id$': { [Op.eq]: { [Op.col]: 'Employee.managerId' } } } }})
Get all CTEs
Get CTE names
Build the WITH clause SQL
Clear all CTEs
Add a simple CTE with a base query