Execute, inspect, and debug raw SQL and SQL builder queries in GORM.
npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-raw-sql
Please help me install this Agent Skill. Skill: gorm-raw-sql Source: https://github.com/liurida/gorm-development-skill/tree/main/raw_sql Command: npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-raw-sql
Working with complex SQL that GORM's high-level APIs cannot express requires low-level execution, inspection, and careful parameter binding to avoid injection, connection leaks, and lost hooks; this Skill explains how to run, inspect, and safely handle raw SQL and SQL builder queries in GORM.
Use the gorm-raw-sql skill to produce a parameterized raw SQL statement with named arguments, show the DryRun/ToSQL output and variables, and explain safe scanning into a target struct.
High-intent search queries and answers about installing and using this skill.
To execute raw SQL queries in GORM, you use low-level Row and Rows access for manual scanning, safely mapping database records directly into target structs or primitives for reporting and ad-hoc queries.
GORM DryRun and ToSQL inspection generate the final SQL statement and bound arguments as output without executing the query, allowing you to debug parameterized queries and SQL builder logic without side effects.
You prevent SQL injection in GORM by using named arguments with parameterized query construction, passing maps or structs as inputs to improve readability and safely bind multiple parameters in complex SQL.
Yes, GORM raw SQL supports clause-based optimizer and index hints for PostgreSQL and MySQL, allowing you to apply low-level database directives to complex reporting queries when needed.
The best way to run multiple statements on the same database connection in GORM is using connection-scoped execution, ensuring sequential raw SQL queries or Row scanning operations share a single session to prevent connection leaks.
You should use GORM raw SQL instead of high-level APIs when your database-focused tasks require complex reporting queries, named-argument binding, or low-level Row scanning that standard ORM methods cannot express.
liuridaDeclare GORM models with gorm.Model embedding and field tags.
jiten-singh-shahiPaginate large SOQL result sets using Database.Cursor and PaginationCursor APIs.
liuridaProvide type-safe CRUD and query operations for GORM models using Go generics.
liuridaEnforce parameterized GORM queries to prevent SQL injection in Go backends.
