query-builder

Setup

Setup a project with sqlite using the following up.sql:

create table example (
    id integer not null primary key,
    calculated integer generated always as (id*2)
);

Versions

• Rust: 1.56.0 nightly
• Diesel: 1.4.7
• Database: Sqlite
• Operating System Linux

Feature Flags

• diesel: sqlite

Problem Description

Sqlite does

Piccolo uses dataclasses extensively, all over the code base.

It's worth investigating if any noticeable performance improvement can be achieved by using Pydantic models instead.

The .returning() function currently only supports strings (which should be the target table's column names). In reality they can accept any expression and (returning) query.

This should be supported:

insert into bar (val) values (123) returning (select count(*) from bar), id, val || 'test'

which would equate to something like:

db.insertInto(bar).values({ val: 123 })