#query-builder #orm #sql #sqlite #postgresql #database-schema


A safe, extensible ORM and Query Builder for PostgreSQL, SQLite, and MySQL

4 releases

0.2.1 May 26, 2023
0.2.0 Aug 29, 2022
0.2.0-rc.1 Jul 22, 2022
0.2.0-rc.0 Apr 22, 2022

#1810 in Database interfaces

Download history 86/week @ 2024-01-01 297/week @ 2024-01-08 198/week @ 2024-01-15 38/week @ 2024-01-22 157/week @ 2024-01-29 213/week @ 2024-02-05 108/week @ 2024-02-12 217/week @ 2024-02-19 59/week @ 2024-02-26 123/week @ 2024-03-04 91/week @ 2024-03-11 186/week @ 2024-03-18 346/week @ 2024-03-25 306/week @ 2024-04-01 492/week @ 2024-04-08 510/week @ 2024-04-15

1,668 downloads per month
Used in diesel-oci


32K SLoC

Query schemas not known at compile time with Diesel

Build Status Gitter

API Documentation: latest release

Diesel is built to provide strong compile time guarantees that your queries are valid. To do this, it needs to represent your schema at compile time. However, there are some times where you don't actually know the schema you're interacting with until runtime.

This crate provides tools to work with those cases, while still being able to use Diesel's query builder. Keep in mind that many compile time guarantees are lost. We cannot verify that the tables/columns you ask for actually exist, or that the types you state are correct.

Getting Started

The main function used by this crate is table. Note that you must always provide an explicit select clause when using this crate.

use diesel_dynamic_schema::table;

let users = table("users");
let id = users.column::<Integer, _>("id");
let name = users.column::<Text, _>("name");

users.select((id, name))

Code of conduct

Anyone who interacts with Diesel in any space, including but not limited to this GitHub repository, must follow our code of conduct.


Licensed under either of these:


Unless you explicitly state otherwise, any contribution you intentionally submit for inclusion in the work, as defined in the Apache-2.0 license, shall be dual-licensed as above, without any additional terms or conditions.


~76K SLoC