prax-query 0.5.0

Type-safe query builder for the Prax ORM
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56

# prax-query

Type-safe query builder for Prax ORM.

## Overview

`prax-query` provides a fluent, type-safe API for building database queries with support for filtering, pagination, relations, and transactions.

## Features

- Fluent query API: `findMany`, `findUnique`, `create`, `update`, `delete`, `upsert`
- Type-safe filtering with AND/OR/NOT combinators
- Pagination with `skip`/`take` and cursor-based navigation
- Aggregation queries: `count`, `sum`, `avg`, `min`, `max`, `groupBy`
- Raw SQL escape hatch with type interpolation
- Connection pooling and configuration
- Middleware/hooks system for query interception
- Multi-tenant support

## Performance

- **1.7ns** simple filter creation (3x faster than Diesel)
- **64 bytes** Filter enum size (fits in single cache line)
- **6.6x faster** SQL string construction vs Diesel

## Usage

```rust
use prax_query::prelude::*;

// Find users with filters
let users = client
    .user()
    .find_many()
    .where(user::email::contains("@example.com"))
    .order_by(user::created_at::desc())
    .take(10)
    .exec()
    .await?;

// Create with nested relations
let user = client
    .user()
    .create(user::Create {
        email: "alice@example.com".into(),
        name: Some("Alice".into()),
        ..Default::default()
    })
    .exec()
    .await?;
```

## License

Licensed under either of Apache License, Version 2.0 or MIT license at your option.