debug_sql!

[mfpiccolo]

It would be really great if you could debug sql commands at compile time. Something like:

debug_sql!(users.filter(id.eq(1));

would output:

SELECT * FROM users WHERE id = 1

Or:

debug_sql!(update(users::table.filter(id.eq(id))).set(changed_user));

prints to console:

UPDATE "users" SET "name" = $1, "email" = $2 WHERE "users"."id" = $3 RETURNING "users"."id", "users"."name", "users"."email"

[sgrif]

Note: I don't think this needs to be a compiler plugin. We just need a DebugQueryBuilder that doesn't need a database connection, and have the macro expand to:

let mut query_builder = DebugQueryBuilder::new();
$query.to_sql(&mut query_builder).unwrap();
println!("{}", &query_builder.sql);