Daniel Townsend

# What is this project? [Piccolo](https://github.com/piccolo-orm/piccolo) is an async ORM and query builder. # Why is it awesome? * Includes a nice, modern [admin interface](https://github.com/piccolo-orm/piccolo_admin). * Builtin [migration support](https://piccolo-orm.readthedocs.io/en/latest/piccolo/migrations/index.html). *...

improve typing for `await Band.objects().first()`

3

Related to https://github.com/piccolo-orm/piccolo/issues/561 When doing this query: ```python band = await Band.objects().first() ``` MyPy now knows the response is `t.Optional[Band]`. This was possible by using `Generic` and `TypeVar` from Python's...

Needs the following doing: * Fix the schema generation tests * Add a bunch more tests

When I'm experimenting with Piccolo queries I typically use the playground: ``` piccolo playground run ``` I try and make the schema used by the playground as fully featured as...

add `tablespace` argument to `Table`

2

Closes https://github.com/piccolo-orm/piccolo/issues/526

### Discussed in https://github.com/piccolo-orm/piccolo/discussions/525 Originally posted by **theelderbeever** May 24, 2022 Background on the question... some of our tables are very large and our deployment infrastructure limits us to 16TB...

add `fake` argument to `MigrationManager`

1

Related to https://github.com/piccolo-orm/piccolo/issues/515

### Discussed in https://github.com/piccolo-orm/piccolo/discussions/514 Originally posted by **theelderbeever** May 16, 2022 Throwing this out there as a possible suggestion. It would be potentially valuable to have an `--sql` option with...

add generic database exceptions

1

Related to https://github.com/piccolo-orm/piccolo/issues/487

prototype Pydantic choice support in `create_pydantic_model`

1

Related to https://github.com/piccolo-orm/piccolo/issues/467 Just a prototype at the moment. If a Piccolo column has choices, we can use the choices `Enum` as the Pydantic type. For example: ```python class RelationshipType(str,...