Wrap a SelectBuilder as a named subquery for use in FROM or JOIN clauses. Note: this consumes the SelectBuilder.
const inner = select('id', 'name').from('users');const sql = select('sub.id').from(subquery(inner, 'sub')).toSql(); Copy
const inner = select('id', 'name').from('users');const sql = select('sub.id').from(subquery(inner, 'sub')).toSql();
Wrap a SelectBuilder as a named subquery for use in FROM or JOIN clauses. Note: this consumes the SelectBuilder.