- some more interpret_as_froms

1 files changed, 18 insertions, 0 deletions

diff --git a/test/orm/test_query.py b/test/orm/test_query.py
index b80db67eb..44e016c86 100644
--- a/test/orm/test_query.py
+++ b/test/orm/test_query.py
@@ -130,6 +130,14 @@ class RawSelectTest(QueryTest, AssertsCompiledSQL):
             "SELECT * FROM users"
         )
 
+    def test_inline_select_from_entity(self):
+        User = self.classes.User
+
+        self.assert_compile(
+            select(['*'], from_obj=User),
+            "SELECT * FROM users"
+        )
+
     def test_select_from_aliased_entity(self):
         User = self.classes.User
         ua = aliased(User, name="ua")
@@ -193,6 +201,16 @@ class RawSelectTest(QueryTest, AssertsCompiledSQL):
             "SELECT ua.id, ua.name FROM users AS ua"
         )
 
+    def test_core_join(self):
+        User = self.classes.User
+        Address = self.classes.Address
+        from sqlalchemy.sql import join
+        self.assert_compile(
+            select([User]).select_from(join(User, Address)),
+            "SELECT users.id, users.name FROM users "
+            "JOIN addresses ON users.id = addresses.user_id"
+        )
+
 class GetTest(QueryTest):
     def test_get(self):
         User = self.classes.User