jonyscathe

### Search before asking - [X] I searched the [issues](https://github.com/sqlfluff/sqlfluff/issues) and found no similar issues. ### Links or command line https://docs.sqlfluff.com/en/stable/configuration.html?highlight=ignore#id1 ### Issue/Suggested Improvement I am guessing what I want...

Improvements in word splitting

1

Just wondering if there is any reason why camel case words aren't always split when checking spelling. In particular if there are camelcase words in a comment then they flag...

TC100 not needed for stub files

15

flake8-pyi has started reporting the following warning if `from __future__ import annotations` is in a stub file: `Y044 "from __future__ import annotations" has no effect in stub files.` This is...

assert_used skips change in 1.7.7

2

### Describe the bug Had pyproject.toml containing the following which worked fine in 1.7.6: ``` [tool.bandit.assert_used] skips = [ 'src/tests/*_test.py', ] ``` This fails in 1.7.7 unless changed to: ```...

[Adjust Rule] SIM401 quotation issue

4

## Desired change * **Rule(s)**: SIM401 * **Adjustment**: The key and default value in the suggested change should have the correct type ## Explanation Makes the suggestion valid python. If...

### Is your feature request related to a problem? Please describe. Currently cannot update to protobuf 5.26.0 due to grpcio-tools dependencies. ### Describe the solution you'd like grpcio-tools requirement for...

Incorrect Q003 error

4

Since 3.4.0 came out I am getting Q003 errors on code such as: ``` string = f'My id is {some_dictionary['id']}' ``` As per f-string changes in python 3.12 it is...

Jonyscathe/execute mutate

2

This adds support for modifying mock_data through any of: ``` session.execute(insert(my_table).values()) # similar to session.add() session.execute(insert(my_table), ) # similar to session.add() session.execute(insert(my_table).returning(my_table), ).scalar() # similar to session.add(), in theory should...

ORM 2.0 style fake session mutations

3

**Is your feature request related to a problem? Please describe.** Cannot currently read mock data back using `session.execute(select(my_table)).all()` **Describe the solution you'd like** Currently the following works: ``` >>> session...

**Describe the bug** After @seano314's update to support sqlalchemy 2.0 I have had success migrating a lot of my code and test code over to 2.0 style form following the...