And it also rare too switch database vendor mid project, some rare constraints if that happens or if you have too much vc money.

And you should use your database to its full capabilities, including vendor specific queries, otherwise you are just wasting computation. Becuase of this I don't even use query builders anymore, just raw SQL.