Pinto

Pinto is a small, easy-to-use library for constructing SQL queries programmatically in Rust.

⚠️ This library does not provide query parameterization. Do not use raw user-supplied data in your queries. If inputs are not properly escaped, your software will be suspectible to SQL injection attacks.

Compatibility

The library aims to generate queries compatible with PostgreSQL, MySQL, and SQLite.

Install

Add pinto as a dependency:

[dependencies]
pinto = "0.6.1"

Example

let query = query_builder::select("users")
    .fields(&["id", "name"])
    .filter("name = $1")
    .order_by("id", query_builder::Order::Asc)
    .build();

assert_eq!("SELECT id, name FROM users WHERE name = $1 ORDER BY id ASC;", query);

See included tests for additional examples.

Features

Statements

• DELETE
  • WHERE clause
• INSERT
• SELECT
  • Table alias (AS)
  • Field selection
  • JOIN clause
  • WHERE clause
  • GROUP BY clause
  • HAVING clause
  • ORDER BY clause
  • LIMIT and OFFSET clause
• UPDATE
  • WHERE clause

Documentation

• "First Steps" (recommended for beginners)
• API documentation

Design Philosophy

Pinto aims to be:

1. Easy-to-use — the library should be useful with a beginner's knowledge of Rust
2. Simple — the library's API should follow common SQL terminology and should allow its users to write concise, readable implementations

Other design goals, such as performance, are relevant but not foremost.

License

MIT