> Databases are much more powerful than we think And a function of what people think is attitudes towards working at the DB level. I see this often with ORM's

> Databases are much more powerful than we think And a function of what people think is attitudes towards working at the DB level. I see this often with ORM's in the web dev sphere (rather than Dat Science). Yes, ORM's are great but many people rely on them to completely abstract away the database and are terrified by raw sql or even query building. You also see it with services that abstract away the backend like PocketBase, Fireship, etc. Writing a window function or even a sub select looks like black magic to many. I say this after several experiences with codebases where joins and filtering were often done at the application layer and raw sql was seen as the devil.