René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Feature: Support Union","articleBody":"This request is to add a feature for SQL Unions.\r\n\r\n\r\nLaravel Docs: [Laravel Eloquent Unions](https://laravel.com/docs/10.x/queries#unions)\r\nMySQL Docs: [MySQL 8.1 UNION Clause](https://dev.mysql.com/doc/refman/8.1/en/union.html)\r\n\r\n\r\n## Union Example\r\nExample SQL input:\r\n```\r\n(select * from `users` where `last_name` is null) union (select * from `users` where `first_name` is null)\r\n```\r\n\r\nExample Eloquent output:\r\n```\r\nDB::table('users')\r\n-\u003ewhereNull('last_name')\r\n-\u003eunion(\r\n            DB::table('users')\r\n            -\u003ewhereNull('first_name')\r\n)\r\n-\u003eget();\r\n```\r\n\r\n## Union All Example\r\n\r\nExample SQL input:\r\n```\r\n(select * from `users` where `last_name` is null) union all (select * from `users` where `first_name` is null)\r\n```\r\n\r\nExample Eloquent output:\r\n```\r\nDB::table('users')\r\n-\u003ewhereNull('last_name')\r\n-\u003eunionAll(\r\n            DB::table('users')\r\n            -\u003ewhereNull('first_name')\r\n)\r\n-\u003eget();\r\n```\r\n\r\n## Union with orderBy on id\r\n\r\nExample SQL input:\r\n```\r\n(select * from `users` where `last_name` is null) \r\nunion\r\n(select * from `users` where `first_name` is null) \r\norder by `id` asc\r\n```\r\n\r\nExample Eloquent output:\r\n```\r\nDB::table('users')\r\n-\u003ewhereNull('last_name')\r\n-\u003eunionAll(\r\n            DB::table('users')\r\n            -\u003ewhereNull('first_name')\r\n)\r\n-\u003eorderBy('id')\r\n-\u003eget();\r\n```\r\n\r\n## Additional Context\r\nWhile Eloquent doesn't handle returning a UNION from multiple models well (everything will be shoved into the first model's class), it does handle it well as a subselect with multiple models. It makes it much easier to scan across many different models as part of a very complex where.","author":{"url":"https://github.com/kassah","@type":"Person","name":"kassah"},"datePublished":"2023-10-23T17:21:21.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/30/sql2builder.github.io/issues/30"}