sql-translation

Guide for adding SQL function translations to dbplyr backends. Critical research required before implementation.

• Add SQL translations for database-specific functions
• Convert R functions to SQL for specific backends
• Supports scalars, aggregates, and window functions
• Uses sql_translation() method in backend files

• MUST research SQL syntax first (critical)
• Use sql_glue() with {x} and {.val x} for interpolation
• Supports scalar, aggregate, and window function translations
• Leverage base_scalar, base_agg, base_win parents
• Add tests and documentation for new functions
• Use existing test structure and examples
• Must run format and test checks after implementation

1. 1.Research SQL syntax using sql-research skill first (CRITICAL)
2. 2.Identify correct backend file (e.g., backend-postgres.R)
3. 3.Add translation to sql_translation() with appropriate parent
4. 4.Test interactively and write unit tests
5. 5.Update backend documentation with key differences
6. 6.Run format, test, and document checks