How to compare results of two subqueries in where clause SQLKata

[sterlyukin]

I try to compare results of two subqueries in where clause in SQLKata.

In SQL it should be like this:

WHERE (SELECT count(id) FROM main.someTable) = (SELECT count(id) FROM main.anotherTable)

In SQLKata I can compare result of subquery with scalar value:

var mainSubquery = new Query("main.someTable")
            .SelectRaw("count(id)");

var anotherSubquery = new Query("main.anotherTable")
            .SelectRaw("count(id)");

query
    .WhereSub(mainSubquery, "=", 0)

But I can't compare results of two subqueries this way:

query
    .WhereSub(mainSubquery, "=", anotherSubquery)

How can I fix it? Maybe I should execute both of the subqueries and only then compare their results? Thanks for response in advance.

[sterlyukin]

Solved here - https://stackoverflow.com/questions/74939077/how-to-compare-result-of-two-subqueries-in-where-clause-sqlkata/74948798#74948798