```rust use typed_sql::{Query, Table, ToSql};
struct User { id: i64, name: String }
let stmt = User::table() .select() .filter(|user| user.id.neq(6).and(user.id.gt(3))) .groupby(|user| user.name) .orderby(|user| user.name.then(user.id.ascending())) .limit(5);
asserteq!( stmt.tosql(), "SELECT * FROM users \ WHERE users.id != 6 AND users.id > 3 \ GROUP BY users.name \ ORDER BY users.name,users.id ASC \ LIMIT 5;" ); ```