Update Black's target-version to py37

<!-- Provide a general summary of your proposed changes in the Title field above -->

### Description
<!-- Describe your changes in detail -->

Black's `target-version` was still set to `['py27', 'py36']`. Set it to `[py37]` instead.

Also update Black and other pre-commit hooks and re-format with Black.

### Checklist
<!-- go over following points. check them with an `x` if they do apply, (they turn into clickable checkboxes once the PR is submitted, so no need to do everything at once)

-->

This pull request is:

- [ ] A documentation / typographical error fix
	- Good to go, no issue or tests are needed
- [ ] A short code fix
	- please include the issue number, and create an issue if none exists, which
	  must include a complete example of the issue.  one line code fixes without an
	  issue and demonstration will not be accepted.
	- Please include: `Fixes: #<issue number>` in the commit message
	- please include tests.   one line code fixes without tests will not be accepted.
- [ ] A new feature implementation
	- please include the issue number, and create an issue if none exists, which must
	  include a complete example of how the feature would look.
	- Please include: `Fixes: #<issue number>` in the commit message
	- please include tests.

**Have a nice day!**

Closes: #7536
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/7536
Pull-request-sha: b3aedf5570d7e0ba6c354e5989835260d0591b08

Change-Id: I8be85636fd2c9449b07a8626050c8bd35bd119d5

1 files changed, 6 insertions, 6 deletions

diff --git a/lib/sqlalchemy/sql/elements.py b/lib/sqlalchemy/sql/elements.py
index f6606e01d..6e5fbba88 100644
--- a/lib/sqlalchemy/sql/elements.py
+++ b/lib/sqlalchemy/sql/elements.py
@@ -516,7 +516,7 @@ class ClauseElement(
         column_keys=None,
         for_executemany=False,
         schema_translate_map=None,
-        **kw
+        **kw,
     ):
         if compiled_cache is not None and dialect._supports_statement_cache:
             elem_cache_key = self._generate_cache_key()
@@ -542,7 +542,7 @@ class ClauseElement(
                     column_keys=column_keys,
                     for_executemany=for_executemany,
                     schema_translate_map=schema_translate_map,
-                    **kw
+                    **kw,
                 )
                 compiled_cache[key] = compiled_sql
             else:
@@ -555,7 +555,7 @@ class ClauseElement(
                 column_keys=column_keys,
                 for_executemany=for_executemany,
                 schema_translate_map=schema_translate_map,
-                **kw
+                **kw,
             )
 
             if not dialect._supports_statement_cache:
@@ -4134,7 +4134,7 @@ class Over(ColumnElement):
         if partition_by is not None:
             self.partition_by = ClauseList(
                 *util.to_list(partition_by),
-                _literal_as_text_role=roles.ByOfRole
+                _literal_as_text_role=roles.ByOfRole,
             )
 
         if range_:
@@ -4667,7 +4667,7 @@ class NamedColumn(ColumnElement):
         name=None,
         name_is_truncatable=False,
         disallow_is_literal=False,
-        **kw
+        **kw,
     ):
         c = ColumnClause(
             coercions.expect(roles.TruncatedLabelRole, name or self.name)
@@ -4965,7 +4965,7 @@ class ColumnClause(
         name=None,
         name_is_truncatable=False,
         disallow_is_literal=False,
-        **kw
+        **kw,
     ):
         # the "is_literal" flag normally should never be propagated; a proxied
         # column is always a SQL identifier and never the actual expression