query-builder

Execute typed CRUD queries against a LiteORM database using Go.

5|Updated Jun 18, 2026
One-click install
npx skills add https://github.com/go-again/liteorm --skill query-builder-go-again
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: query-builder
Source: https://github.com/go-again/liteorm/tree/main/skills/query-builder
Command: npx skills add https://github.com/go-again/liteorm --skill query-builder-go-again

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires liteorm, and includes scripts (resource) components.

What problem does it solve?

This Skill unit simplifies the process of writing explicit, typed queries with LiteORM's query front-end, allowing developers to efficiently build and execute complex queries without the need for SQL knowledge.

Core Features & Use Cases

  • Typed Queries: Write queries using typed predicates and column expressions, ensuring compile-time type safety.
  • CRUD Operations: Perform Create, Read, Update, and Delete operations on database records.
  • Join and Subqueries: Support for joins and subqueries to build complex query logic.
  • Use Case: For a project that requires filtering and aggregating data from a database, this skill unit can be used to build and execute queries efficiently.

Quick Start

Use the query-builder skill to select users with an 'active' status and order them by 'created_at' in descending order.

Frequently Asked Questions about query-builder

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build typed database queries in Go without writing raw SQL?

You can build typed database queries in Go by using a query builder that supports typed predicates and column expressions. This approach provides compile-time type safety for filtering, grouping, and joining data without requiring SQL knowledge.

What is the best way to perform CRUD operations on a LiteORM database in Go?

The best way to perform CRUD operations on a LiteORM database in Go is by using a query builder front-end. It allows you to create, read, update, and delete records through typed queries rather than constructing manual SQL strings.

Can I execute complex joins and subqueries using a Go query builder?

Yes, you can execute complex joins and subqueries using a Go query builder. It supports building advanced query logic by combining typed column expressions for filtering and aggregating data from related database tables.

Do I need LiteORM installed to execute typed Go queries for database filtering?

Yes, you need LiteORM installed and configured with an active database connection. The query builder operates as a front-end for LiteORM, requiring this dependency to execute typed Go queries and retrieve your filtered results.

How does compile-time type safety work when filtering Go database records?

Compile-time type safety works by using typed predicates and column expressions to structure your database queries. This ensures that the query parameters match your Go struct definitions before the code compiles, preventing runtime type errors.

How do I order and filter Go database records by specific column attributes?

To filter and order Go database records, you use the query builder to apply typed predicates for filtering, such as selecting active statuses, and then specify column expressions like 'created_at' to order the results descending.