order by case clause possible?

can i model this in drizzle? order by case when date >= today then date else null end asc, case when date < today then date else null end desc or should i just use sql