René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Optionally relax sqlglot / ibis pin via env var for use in SQLMesh","articleBody":"https://github.com/googleapis/python-bigquery-dataframes/blob/04139644af0c30c10519397fb3be7bebf6ec813c/setup.py#L63\r\n\r\nThere is very strong synergy between bigframes and https://github.com/TobikoData/sqlmesh\r\nHowever because of the sqlglot pin and the transitive sqlglot pin in the ibis pin, this library is incompatible with sqlmesh. (sqlmesh is built and maintained by creators of sqlglot and therefore usually has latest pin, and a strict one at that)\r\n\r\nSince you are using setup.py, we should be able to use an env var or something similar to have an `opt-in` way to remove the version constraints on those two deps such that they can be defined by the consumer. We would accept that it opens one up to undefined behavior but by contrast it frees you from needing to constantly update your pins and allows more experimentation and adoption in the community. \r\n\r\nYou can see an example sqlmesh model using bigframes here https://github.com/TobikoData/sqlmesh/pull/2667/files","author":{"url":"https://github.com/z3z1ma","@type":"Person","name":"z3z1ma"},"datePublished":"2024-08-30T15:20:28.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/942/python-bigquery-dataframes/issues/942"}