René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Render empty whereIn as 1 = 2","articleBody":"**Is your feature request related to a problem? Please describe.**\r\nCurrently an empty whereIn clause will render as empty list which results in a MySQL error.\r\n\r\n**Describe the solution you'd like**\r\nAn empty whereIn clause should render as `1 = 2` or some other false statement in order to replicate the expected behavior of `WHERE x IN ()`\r\n\r\n**Describe alternatives you've considered**\r\nExcluding the statement is another option but that's dangerous as sensitive data might be exposed that otherwise would have been filtered by the IN clause and doesn't really match the expected behavior of `does the set () include element x`.\r\n","author":{"url":"https://github.com/JanHolger","@type":"Person","name":"JanHolger"},"datePublished":"2022-04-07T15:37:29.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/35/orm/issues/35"}