skills.rest
avvale
avvaleOFFICIAL
Explore all skills by this author →
WebsiteGitHub

aurora-criteria

Build complex database queries using Aurora QueryStatement in NestJS.

Updated Jan 26, 2023
Search Tags:#database#filtering#orm#pagination#nestjs#aurora#querybuilder
One-click install
npx skills add https://github.com/avvale/aurora-back --skill aurora-criteria
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: aurora-criteria
Source: https://github.com/avvale/aurora-back/tree/main/.claude/skills/aurora-criteria
Command: npx skills add https://github.com/avvale/aurora-back --skill aurora-criteria

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a comprehensive guide to using Aurora's QueryStatement, enabling developers to efficiently build complex database queries, filters, and pagination logic, thereby streamlining data retrieval operations.

Core Features & Use Cases

  • Query Building: Construct sophisticated WHERE clauses with various operators (logical, comparison, string, etc.).
  • Data Shaping: Control which fields are returned (attributes) and how relationships are loaded (include).
  • Pagination & Sorting: Implement efficient data fetching with limit, offset, and order.
  • Use Case: When building a feature to search for products with specific criteria (e.g., price range, category, availability) and display them in a paginated list, this Skill guides you on structuring the QueryStatement.

Quick Start

Use the aurora-criteria skill to build a QueryStatement to find all users created after January 1st, 2023, sorted by their creation date in descending order.

Frequently Asked Questions about aurora-criteria

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

FAQPage Schema
How do I build complex database queries with filtering and pagination in NestJS?▼

Build complex database queries in NestJS by using the Aurora QueryStatement interface to construct WHERE clauses, apply various operators, and configure limit and offset for pagination.

What is the Aurora QueryStatement interface used for in NestJS applications?▼

The Aurora QueryStatement interface is used for data retrieval in NestJS, enabling developers to shape results through field selection, eager loading relationships, sorting, and grouping.

How do I implement eager loading and field selection when querying a database in NestJS?▼

Implement eager loading and field selection in NestJS by configuring the QueryStatement to specify returned attributes and define relationship includes within your database query.

Can I use logical and comparison operators for database filtering in NestJS with Aurora?▼

Yes, you can use logical, comparison, and string operators for database filtering in NestJS by applying the correct operator syntax within the Aurora QueryStatement structure.

How do I secure user-provided database queries and prevent unauthorized data access in NestJS?▼

Secure user-provided database queries in NestJS by maintaining a strict distinction between user-provided query parameters and system constraints within the Aurora QueryStatement.

Does Aurora QueryStatement support sorting and grouping for paginated lists in NestJS?▼

Yes, Aurora QueryStatement supports sorting and grouping for paginated lists in NestJS by configuring the order and grouping parameters alongside limit and offset.

Related Skills

Explore More Software Engineering Skills→
giosuetedeschi-specgiosuetedeschi-spec

neon-postgres

Configure Neon serverless Postgres connection pooling and ORM driver integration.

Community
Intermediate
ShadylukinShadylukin
74

neumann-client

Connect Rust, Python, and TypeScript apps to Neumann via gRPC for queries and vector operations.

Community
Intermediate
allenlin90allenlin90
1

backend-controller-pattern-nestjs

Consolidates NestJS controllers into a unified pattern library with base controllers and Zod serialization.

Community
Advanced
EIS-ITSEIS-ITS

Backend Queries

Generate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.

Official
Intermediate