How does this skill assist with dbplyr development?

It focuses specifically on the details needed for R-to-SQL translation, such as index handling (0-based vs 1-based), return types, and window function specifications.

Does this skill automatically write SQL code?

No, it focuses on the research phase. It helps gather the necessary facts and documentation so that the subsequent implementation of SQL-generating code is accurate and robust.

Where are the research findings stored?

The skill follows a pattern of creating standardized Markdown files within a 'research/' directory, organized by dialect and command name.

Which databases does this skill support?

It is dialect-agnostic and can be used to research any SQL database, including PostgreSQL, SQL Server, MySQL, SQLite, Oracle, and BigQuery.

What is the primary goal of the SQL Research skill?

The primary goal is to ensure SQL correctness by requiring thorough research and documentation of database-specific syntax and behaviors before any code is implemented.

SQL Research & Documentation

Name: SQL Research & Documentation
Author: Activer007

byActiver007

Gestión de Bases de Datos

Researches and documents database-specific SQL syntax and behaviors to ensure accurate R-to-SQL translations for dbplyr.

Acerca de

The SQL Research skill provides a rigorous, standardized workflow for investigating SQL dialects and features before implementation. It guides the AI through searching official documentation, identifying critical edge cases like NULL handling and 0-vs-1 indexing, and creating structured research files. By enforcing a 'documentation-first' principle, it ensures that SQL-generating code, particularly for tools like dbplyr, is built on a foundation of verified technical facts across diverse backends such as PostgreSQL, SQL Server, and BigQuery.

Características Principales

Standardized research templates for SQL functions and commands
Comprehensive checklists for SQL correctness and reliability
0 GitHub stars
Focus on R-to-SQL translation nuances like type coercion
Multi-source verification workflow for database edge cases
Version-specific feature tracking and documentation

Casos de Uso

Documenting database-specific limitations and NULL behaviors
Researching syntax differences between various SQL dialects
Developing and maintaining dbplyr database backends

Acerca de

Características Principales

Standardized research templates for SQL functions and commands
Comprehensive checklists for SQL correctness and reliability
0 GitHub stars
Focus on R-to-SQL translation nuances like type coercion
Multi-source verification workflow for database edge cases
Version-specific feature tracking and documentation

Casos de Uso

Documenting database-specific limitations and NULL behaviors
Researching syntax differences between various SQL dialects
Developing and maintaining dbplyr database backends