Hello there. Do you guys think prisma is the right choice, if i need to make more advanced queries ( for different analytics and such .. ), with joins and aggregation methods ? Or does it actually offer the possibility of making raw sql query ?

This was something that was planned for a Q3 release as stated in this issue thread: https://github.com/prisma/prisma/issues/1312 but it has been delayed, explanation here: https://github.com/prisma/prisma/issues/62#issuecomment-438664572

Prisma does have a raw queries api by now, you might want to use that one.

By raw do you mean writing sql queries .. or raw graphql queries ? @dpetrick

https://prismagraphql.com/docs/1.22/prisma-graphql-api/reference/raw-database-access-qwe4/ @pllumh

Yes that link is correct. I believe it’s only for the SQL connectors at the moment. And yes, it’s raw SQL.

@Priyank Patel Thanks !! That great !