native-query-filter

What problem does it solve?

Integrates TypeORM with native PostgreSQL get_filtered_list to enable dynamic, filterable list APIs with efficient pagination and joins.

Core Features & Use Cases

• Config-driven filters define a whitelist of allowed keys, ensuring secure and predictable query construction.
• Performance optimization offloads complex filtering to native SQL for faster responses on large datasets.
• Use Case: Build admin list endpoints with multi-join filtering and paginated results, while keeping a clean configuration.

Quick Start

Configure the YAML config for your entity, load it with FilteredListBuilder, and call get_filtered_list with the config, filters, and pagination to retrieve results.