Function subquery 

pub fn subquery(query: SelectBuilder, alias_name: &str) -> Expr

Wrap a SelectBuilder as a named subquery for use in FROM or JOIN clauses.

The resulting Expr can be passed to SelectBuilder::from_expr() or used in a join condition.

Examples

use polyglot_sql::builder::*;

let inner = select(["id", "name"]).from("users").where_(col("active").eq(boolean(true)));
let sql = select(["sub.id"])
    .from_expr(subquery(inner, "sub"))
    .to_sql();
assert_eq!(
    sql,
    "SELECT sub.id FROM (SELECT id, name FROM users WHERE active = TRUE) AS sub"
);