Getting Raw SQL from the package, without passing it to the database engine

[Amin-ir]

Getting Raw SQL from the package, without passing it to the database engine

[Amin-ir]

Fantastic! you see, I feel the queries so much more readable once written using SqlKata chaining methods, and then only converted to raw SQL to be fed into an ORM.
TY!

[ahmad-moussawi]

You're right. Is there any other way to compile query?

If you are not the SqlKata.Execution package, you should use the SqlResult class to get the SQL string with the parameters bindings.

See https://github.com/sqlkata/querybuilder/blob/master/SqlKata.Execution/QueryFactory.cs#L77 as an example

[Revazashvili]

Yes, you can. package contains compilers for every database it supports, under SqlKata.Compilers namespace.

you can use Compile method to get SqlResult which contains Sql and RawSql properties. if you want to get Sql parsed with actually passed parameters call ToString() method on SqlResult.

Example with postgres;

var query = new Query();
var compiler = new PostgresCompiler();
var sqlResult = compiler.Compile(query);
var sql = sqlResult.ToString();

[ahmad-moussawi]

It is worth noting that the ToString() method is meant only for debugging purposes and not for executing queries.
Check https://sqlkata.com/docs#compile-only-example

[Revazashvili]

You're right. Is there any other way to compile query?