query-builder

Consider the following code (using AsChangeset instead / in addition to Insertable produces the same error message):

#[derive(Insertable)]
struct Foo {
        #[column_name = "type"]
        ty: String
}

This code is wrong because eventhough the table has a column called type, the auto-generated schema.rs file renames that to type_ to avoid using a keyword as an

Piccolo now has a command for generating a schema from an existing database.

piccolo schema generate

The current implementation doesn't cover every possible edge case and database feature, so there's room for improvement. For example:

Column defaults

Getting the defaults for a column, and reflecting them in the Piccolo column. For example, if the column has a default o

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 })