1 files changed, 5 insertions, 1 deletions
diff --git a/src/main/java/org/zwobble/hobgoblin/compiler/output/generators/sql/SqlGenerator.java b/src/main/java/org/zwobble/hobgoblin/compiler/output/generators/sql/SqlGenerator.java
index 82d483e..624b3fe 100644
--- a/src/main/java/org/zwobble/hobgoblin/compiler/output/generators/sql/SqlGenerator.java
+++ b/src/main/java/org/zwobble/hobgoblin/compiler/output/generators/sql/SqlGenerator.java
@@ -76,7 +76,11 @@ public class SqlGenerator {
                 return new SqlSelectStatement(
                     columns,
                     generateTableName(table.name()),
-                    List.of()
+                    List.of(
+                        new SqlOrderingTerm(new SqlRef(
+                            generateColumnName(tableInfo.primaryKey().name())
+                        ))
+                    )
                 );
             }
         }