packages/common/prisma/migrations/20250212092300_view_aws_vpcs/migration.sql [70:83]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
                            from        part1 as d
                            where       d.is_main = true
                                        and subnet.vpc_id = d.vpc_id
                                        and subnet.request_account_id = d.account_id
                                        and subnet.request_region = d.region

                            /*
                             From `part1` we have a row for each route in a route table.
                             By ordering by `route_type` and taking the first item, we say a subnet is public if it has a public route.
                             This is a bit of a hack, as it relies on "public" being alphabetically before "private", but it works for now.
                            */
                            order by    d.route_type desc
                            limit       1
                          )
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



packages/common/prisma/migrations/20250212092300_view_aws_vpcs/migration.sql [89:96]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
                            from        part1 as d
                            where       d.is_main = true
                                        and subnet.vpc_id = d.vpc_id
                                        and subnet.request_account_id = d.account_id
                                        and subnet.request_region = d.region
                            order by    d.route_type desc -- see above for an explanation of this
                            limit       1
                        )
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



