withSchema is marked as deprecated in ExpressionBuilder?
why and how to be replaced? How can be the schema defined dynamically (env)?
2 Replies
It's only going to be removed from the expression builder. It'll stay in the query builders.
Is there some particular case where you need it in the expression builder specifically? You don't need to specify the schema for subqueries and such if you've specified it for the top level query.
Here's an example: https://kyse.link/?p=s&i=XWchUogx2oxV6evj5naA
I don't use
withSchema on the expression builder there at allwe use kysely in combination with sequelize - for both main queries and subqueries. several tables are in different schemas and they interact (joins, subqueries) together. it worth to do some analysis and testing but I have "a feeling" there could be a problem...
we also use kysely with umzug migrations