But with a few workarounds it was possible to make it work and is quite nice to use.
Example of missing features:
Primary key as a combination of two relational models: https://github.com/prisma/prisma1/issues/3553
Database Constraints https://github.com/prisma/prisma1/issues/728
Cascading Deletes https://github.com/prisma/prisma1/issues/1262
Upsert https://github.com/prisma/prisma1/issues/2194
On delete restrict https://github.com/prisma/prisma1/issues/2701
Mutation CreateOrConnect https://github.com/prisma/prisma1/issues/3724
Improving performance with Indexes https://github.com/prisma/prisma1/issues/1300
Multiple field unique constraint https://github.com/prisma/prisma1/issues/171
Interface types https://github.com/prisma/prisma1/issues/83
Embedded Types https://github.com/prisma/prisma1/issues/2836
Declarative support for multi-field unique constraints https://github.com/prisma/prisma1/issues/1237
Support union types https://github.com/prisma/prisma1/issues/165
Transactions for multiple mutations https://github.com/prisma/prisma1/issues/74