fix: select database fix (#16472)

* select database fix

* made a backend change

(cherry picked from commit e2469162fa074af229ff97e845755caf1a29ca0d)
diff --git a/superset/views/core.py b/superset/views/core.py
index 1c9bf28..c9149f9 100755
--- a/superset/views/core.py
+++ b/superset/views/core.py
@@ -3026,12 +3026,12 @@
             .first()
         )
 
-        databases: Dict[int, Any] = {
-            database.id: {
+        databases: Dict[int, Any] = {}
+        for database in DatabaseDAO.find_all():
+            databases[database.id] = {
                 k: v for k, v in database.to_json().items() if k in DATABASE_KEYS
             }
-            for database in DatabaseDAO.find_all()
-        }
+            databases[database.id]["backend"] = database.backend
         queries: Dict[str, Any] = {}
 
         # These are unnecessary if sqllab backend persistence is disabled