sql-research

What problem does it solve?

This Skill addresses the critical need for accurate and reliable SQL syntax and behavior knowledge across various database dialects. It prevents errors and ensures robust database interactions by guiding thorough research before any SQL-related implementation.

Core Features & Use Cases

• Structured Research Workflow: Guides you through a systematic process to find, document, and verify SQL specifics from official database documentation.
• Database-Specific Insights: Focuses on crucial nuances like NULL handling, type coercion, version differences, and edge cases that are vital for accurate R-to-SQL translation.
• Use Case: Before implementing a new date function translation for PostgreSQL in dbplyr, use this skill to thoroughly research DATE_TRUNC's syntax, arguments, return types, and behavior in PostgreSQL's official documentation.

Quick Start

Research the STRING_AGG function in SQL Server, including its syntax, key behaviors, and limitations, and document your findings.