Remove deprecated elements from selectable.py; remove lockmode

Removed autocommit and legacy "for update" / "lockmode" elements
from selectable.py / query.py.  lockmode was removed from
selectable in 693938dd6fb2f3ee3e031aed4c62355ac97f3ceb
however was not removed from the ORM.

Also removes the ignore_nonexistent_tables option on
join().

Change-Id: I0cfcf9e6a8d4ef6432c9e25ef75173b3b3f5fd87
Partially-fixes: #4643

2 files changed, 2 insertions, 36 deletions

diff --git a/lib/sqlalchemy/sql/elements.py b/lib/sqlalchemy/sql/elements.py
index 843732f67..5a10611ad 100644
--- a/lib/sqlalchemy/sql/elements.py
+++ b/lib/sqlalchemy/sql/elements.py
@@ -1535,9 +1535,7 @@ class TextClause(
         ),
     )
     @_document_text_coercion("text", ":func:`.text`", ":paramref:`.text.text`")
-    def _create_text(
-        self, text, bind=None, bindparams=None, typemap=None,
-    ):
+    def _create_text(self, text, bind=None, bindparams=None, typemap=None):
         r"""Construct a new :class:`.TextClause` clause, representing
         a textual SQL string directly.
 
diff --git a/lib/sqlalchemy/sql/selectable.py b/lib/sqlalchemy/sql/selectable.py
index 45b9e7f9d..3c23704c5 100644
--- a/lib/sqlalchemy/sql/selectable.py
+++ b/lib/sqlalchemy/sql/selectable.py
@@ -833,22 +833,8 @@ class Join(FromClause):
         return self._join_condition(left, right, a_subset=left_right)
 
     @classmethod
-    @util.deprecated_params(
-        ignore_nonexistent_tables=(
-            "0.9",
-            "The :paramref:`.join_condition.ignore_nonexistent_tables` "
-            "parameter is deprecated and will be removed in a future "
-            "release.  Tables outside of the two tables being handled "
-            "are no longer considered.",
-        )
-    )
     def _join_condition(
-        cls,
-        a,
-        b,
-        ignore_nonexistent_tables=False,
-        a_subset=None,
-        consider_as_foreign_keys=None,
+        cls, a, b, a_subset=None, consider_as_foreign_keys=None
     ):
         """create a join condition between two tables or selectables.
 
@@ -864,9 +850,6 @@ class Join(FromClause):
         between the two selectables.   If there are multiple ways
         to join, or no way to join, an error is raised.
 
-        :param ignore_nonexistent_tables: unused - tables outside of the
-         two tables being handled are not considered.
-
         :param a_subset: An optional expression that is a sub-component
          of ``a``.  An attempt will be made to join to just this sub-component
          first before looking at the full ``a`` construct, and if found
@@ -1115,10 +1098,6 @@ class Join(FromClause):
         argument as a no-op, so that the argument can be passed to the
         ``alias()`` method of any selectable.
 
-        .. versionadded:: 0.9.0 Added the ``flat=True`` option to create
-          "aliases" of joins without enclosing inside of a SELECT
-          subquery.
-
         :param name: name given to the alias.
 
         :param flat: if True, produce an alias of the left and right
@@ -1126,8 +1105,6 @@ class Join(FromClause):
          two selectables.   This produces join expression that does not
          include an enclosing SELECT.
 
-         .. versionadded:: 0.9.0
-
         .. seealso::
 
             :ref:`core_tutorial_aliases`
@@ -1333,8 +1310,6 @@ class Alias(AliasedReturnsRows):
          is an instance of :class:`.Join` - see :meth:`.Join.alias`
          for details.
 
-         .. versionadded:: 0.9.0
-
         """
         return coercions.expect(
             roles.FromClauseRole, selectable, allow_select=True
@@ -2021,8 +1996,6 @@ class ForUpdateArg(ClauseElement):
     ):
         """Represents arguments specified to :meth:`.Select.for_update`.
 
-        .. versionadded:: 0.9.0
-
         """
 
         self.nowait = nowait
@@ -2386,11 +2359,6 @@ class GenerativeSelect(DeprecatedSelectBaseGenerations, SelectBase):
     represents a fixed textual string which cannot be altered at this level,
     only wrapped as a subquery.
 
-    .. versionadded:: 0.9.0 :class:`.GenerativeSelect` was added to
-       provide functionality specific to :class:`.Select` and
-       :class:`.CompoundSelect` while allowing :class:`.SelectBase` to be
-       used for other SELECT-like objects, e.g. :class:`.TextualSelect`.
-
     """
 
     _order_by_clauses = ()