Execute raw SQL with GORM for reads, writes, and DDL.
npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-sql-builder
Please help me install this Agent Skill. Skill: gorm-sql-builder Source: https://github.com/liurida/gorm-development-skill/tree/main/sql_builder Command: npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-sql-builder
GORM users often need to run low-level SQL and fine-tune queries while still leveraging the ORM for models and relationships. This Skill provides direct access to raw SQL execution, clause customization, and debugging utilities to build efficient, database-specific queries without sacrificing ORM integration.
Start by writing a raw SQL query with db.Raw and scanning the result into a struct.
High-intent search queries and answers about installing and using this skill.
GORM allows executing raw SQL while preserving ORM models by using the db.Raw API to run custom statements and scan returned rows directly into existing structs or primitive types.
The best way to preview a GORM query before execution is using the ToSQL dry-run generation utility, which renders the executable SQL string without touching the database to validate clause composition and parameter binding.
Yes, you can use named arguments with db.Raw in GORM to safely bind map or struct parameters to your SQL statements, ensuring precise parameter binding and secure handling of query inputs.
GORM supports custom clauses for complex inserts and updates by allowing you to apply and compose tailored clause expressions, enabling database-specific query construction without sacrificing underlying ORM integration.
You optimize repeated raw SQL execution paths in GORM by enabling prepared statements, which pre-compile the query structure to improve performance across iterative db.Raw or db.Exec operations.
You should use GORM raw SQL execution instead of standard ORM methods when you need low-level database-specific tuning, complex clause composition, or precise SQL generation that standard ORM chaining cannot achieve.
liuridaRetrieve the underlying *sql.DB* object from a GORM *gorm.DB* instance.
4lermanGenerate SQL queries, introspect schemas, optimize performance, and create migration scripts.
javierhbrGuide Go developers on implementing data persistence with SQL, ORMs, and migrations.
isharoverwhiteImplement SQLAlchemy 2.0 ORM models for Python database operations.
