What's new in SeaQuery 0.27.0

// beforesea_query::sea_query_driver_postgres!();use sea_query_driver_postgres::{bind_query, bind_query_as};let (sql, values) = Query::select()    .from(Character::Table)    .expr(Func::count(Expr::col(Character::Id)))    .build(PostgresQueryBuilder);let row = bind_query(sqlx::query(&sql), &values)    .fetch_one(&mut pool)    .await    .unwrap();// nowuse sea_query_binder::SqlxBinder;let (sql, values) = Query::select()    .from(Character::Table)    .expr(Func::count(Expr::col(Character::Id)))    .build_sqlx(PostgresQueryBuilder);let row = sqlx::query_with(&sql, values)    .fetch_one(&mut pool)    .await    .unwrap();// You can now make use of SQLx's `query_as_with` nicely:let rows = sqlx::query_as_with::<_, StructWithFromRow, _>(&sql, values)    .fetch_all(&mut pool)    .await    .unwrap();

let query = Query::select()    .column(Char::Id)    .from(Char::Table)    .and_where(        Expr::col(Char::Id)            .eq(                Expr::any(                    Query::select().column(Char::Id).from(Char::Table).take()                )            )    )    .to_owned();assert_eq!(    query.to_string(MysqlQueryBuilder),    r#"SELECT `id` FROM `character` WHERE `id` = ANY(SELECT `id` FROM `character`)"#);assert_eq!(    query.to_string(PostgresQueryBuilder),    r#"SELECT "id" FROM "character" WHERE "id" = ANY(SELECT "id" FROM "character")"#);

let query = Query::insert()    .into_table(Glyph::Table)    .columns([Glyph::Aspect, Glyph::Image])    .values_panic(vec![        2.into(),        3.into(),    ])    .on_conflict(        OnConflict::column(Glyph::Id)            .update_expr((Glyph::Image, Expr::val(1).add(2)))            .target_and_where(Expr::tbl(Glyph::Table, Glyph::Aspect).is_null())            .to_owned()    )    .to_owned();assert_eq!(    query.to_string(MysqlQueryBuilder),    r#"INSERT INTO `glyph` (`aspect`, `image`) VALUES (2, 3) ON DUPLICATE KEY UPDATE `image` = 1 + 2"#);assert_eq!(    query.to_string(PostgresQueryBuilder),    r#"INSERT INTO "glyph" ("aspect", "image") VALUES (2, 3) ON CONFLICT ("id") WHERE "glyph"."aspect" IS NULL DO UPDATE SET "image" = 1 + 2"#);assert_eq!(    query.to_string(SqliteQueryBuilder),    r#"INSERT INTO "glyph" ("aspect", "image") VALUES (2, 3) ON CONFLICT ("id") WHERE "glyph"."aspect" IS NULL DO UPDATE SET "image" = 1 + 2"#);

// Before: will extend current Conditionassert_eq!(    Query::select()        .cond_where(any![Expr::col(Glyph::Id).eq(1), Expr::col(Glyph::Id).eq(2)])        .cond_where(Expr::col(Glyph::Id).eq(3))        .to_owned()        .to_string(PostgresQueryBuilder),    r#"SELECT WHERE "id" = 1 OR "id" = 2 OR "id" = 3"#);// Before: confusing, since it depends on the order of invocation:assert_eq!(    Query::select()        .cond_where(Expr::col(Glyph::Id).eq(3))        .cond_where(any![Expr::col(Glyph::Id).eq(1), Expr::col(Glyph::Id).eq(2)])        .to_owned()        .to_string(PostgresQueryBuilder),    r#"SELECT WHERE "id" = 3 AND ("id" = 1 OR "id" = 2)"#);// Now: will always conjoin with `AND`assert_eq!(    Query::select()        .cond_where(Expr::col(Glyph::Id).eq(1))        .cond_where(any![Expr::col(Glyph::Id).eq(2), Expr::col(Glyph::Id).eq(3)])        .to_owned()        .to_string(PostgresQueryBuilder),    r#"SELECT WHERE "id" = 1 AND ("id" = 2 OR "id" = 3)"#);// Now: so they are now equivalentassert_eq!(    Query::select()        .cond_where(any![Expr::col(Glyph::Id).eq(2), Expr::col(Glyph::Id).eq(3)])        .cond_where(Expr::col(Glyph::Id).eq(1))        .to_owned()        .to_string(PostgresQueryBuilder),    r#"SELECT WHERE ("id" = 2 OR "id" = 3) AND "id" = 1"#);

// Before: notice the tupleOnConflict::column(Glyph::Id).update_expr((Glyph::Image, Expr::val(1).add(2)))// After: it accepts `Value` as well as `SimpleExpr`OnConflict::column(Glyph::Id).value(Glyph::Image, Expr::val(1).add(2))

// Now we can write:ColumnDef::new(Char::FontId)    .timestamp()    .default(Keyword::CurrentTimestamp)