fix(db-postgres): _order is removed from read transform

packages/drizzle/src/transform/read/traverseFields.ts

@@ -666,9 +666,10 @@ export const traverseFields = <T extends Record<string, unknown>>({
             withinArrayOrBlockLocale: locale || withinArrayOrBlockLocale,
           })
 
-          if ('_order' in ref) {
-            delete ref._order
-          }
+          // TODO: we need to only clean this up for arrays, blocks, and hasMany fields
+          // if ('_order' in ref) {
+          //   delete ref._order
+          // }
 
           return
         }

test/sort/collections/Orderable/index.ts

@@ -23,5 +23,15 @@ export const OrderableCollection: CollectionConfig = {
       type: 'relationship',
       relationTo: orderableJoinSlug,
     },
+    {
+      name: 'group',
+      type: 'group',
+      fields: [
+        {
+          name: 'text',
+          type: 'text',
+        },
+      ],
+    },
   ],
 }