Implement StatementBuilder for sea_query::WithQuery

[torleivf]

Motivation

Avoid hard-coding database backend when executing recursive CTE queries, e.g. in the following code:

    let inherits_query = select.with(with_clause).to_owned();

    let builder = db.get_database_backend();

    // This common SelectStatement runs successfully
    let inherits = Inherits::find_by_statement(
        builder.build(&inherits_base_query))
        .all(db).await?;

    // This WithQuery fails as the trait `StatementBuilder` is not implemented for `WithQuery`
    let inherits = Inherits::find_by_statement(
        builder.build(&inherits_query))
        .all(db).await?;

Proposed Solutions

Review and merge #1679

Current Workarounds

Hardcode backend as in this code:

let inherits_query = select.with(with_clause).to_owned();

let db_backend = db.get_database_backend();
// let builder = db_backend.get_query_builder();  //Desired way to get SQLBuilder
let builder = MySqlQueryBuilder::default();  //Manual way to get SQLBuilder

// Query Statement from WithQuery string
let inherits = Inherits::find_by_statement(
        Statement::from_string(
            db_backend, 
            inherits_query.to_string(builder))
        ).all(db).await?;

[tyt2y3]

It seems like we need to publish a new version for SeaQL/sea-query@58e7909

[tyt2y3]

https://github.com/SeaQL/sea-orm/actions/runs/7059056844 passes!

[torleivf]

I can verify that it works on master now, thanks. I guess the tests in 869e324 are still useful.

[tyt2y3]

thanks! then I am going to release it today

[tyt2y3]

thanks, I totally forgot about #1679 either

[github-actions]

🎉 Released In 0.12.8 🎉

Thank you everyone for the contribution!
This feature is now available in the latest release. Now is a good time to upgrade!
Your participation is what makes us unique; your adoption is what drives us forward.
You can support SeaQL 🌊 by starring our repos, sharing our libraries and becoming a sponsor ⭐.