Ditch Sequelize

[KNOXDEV]

Long story short its basically just a piece of shit.

Overall it is definitely an improvement over what we had before, but it has caused a large number of issues. It has very weak support for aggregations and typescript, and there are many places in the code where I have to waste lots of time fighting it to get simple functionality.

Most of all it has singlehandedly made the entire codebase ugly.

I don't know what we should use instead, but I'm not above also just writing something better ourselves. There's another option called Prisma that might be worth looking into as well.

[StormFireFox1]

My own two cents from personal experience:

Prisma is very nice to demo databases with and it's quick for simple CRUD projects; TypeScript support is good, and there's built-in aggregations and grouping, etc.

The only mildly annoying part is that the query language is object-based with not a lot of documentation rather than just using functions. I think because of that there's a "Prisma DSL" you kinda have to learn. It's not bad, but it takes some getting used to.