Design a custom pypika expression named SafeDivide that generates SQL preventing division-by-zero errors…
Design a custom pypika expression named SafeDivide that generates SQL preventing division-by-zero errors…: a task in r2e-code-instruct-qwen3.5 (Harbor dataset). Input/Output: - SafeDivide(table.a, table.b).get sql() → COALESCE(a, '0') / NULLIF(b, '0') - SafeDivide(table.a).get sql() → raises…
The task
Input/Output: - `SafeDivide(table.a, table.b).get_sql()` → `COALESCE(a, '0') / NULLIF(b, '0')` - `SafeDivide(table.a).get_sql()` → raises `ValueError` - `SafeDivide(table.a, t.b, t.c).get_sql()` → raises `ValueError`
Part of Essacheez/r2e-code-instruct-qwen3.5.