sql-research

Guide for researching SQL syntax and behavior for database backends before implementing translations in dbplyr.

• Research SQL syntax and behavior for database backends
• Ensure SQL correctness in dbplyr implementations
• Document database-specific SQL features
• Support translation from R to SQL

• MUST complete research before implementing SQL code
• Prioritize official documentation sources
• Include all source URLs in documentation
• Focus on dbplyr translation needs only
• Cross-reference multiple authoritative sources
• Document edge cases and limitations
• Keep documentation minimal and focused
• Verify behavior across versions and edge cases

1. 1.Search for official documentation of {dialect} {function/command}
2. 2.Create research file in `research/{dialect}-{command}.md`
3. 3.Structure with summary, syntax, behaviors, limitations, sources
4. 4.Cross-reference multiple sources if unclear or conflicting
5. 5.Only proceed to implementation after completing research and documentation
6. 6.Include all URLs and keep documentation concise