René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Returning data from modified rows","articleBody":"#### Environment details\r\n\r\n  - Programming language: `python`\r\n  - OS: `13.4 (22F66)`\r\n  - Language runtime version: `3.11`\r\n  - Package version: \r\n`sqlalchemy-spanner==1.6.1`\r\n`SQLAlchemy==2.0.15`\r\n\r\n#### Steps to reproduce\r\n\r\n1. Create an update/insert statement\r\n```python\r\nupdate_stmt = (\r\n    update(DBModel)\r\n    .values(\r\n        **db_record.dict(exclude_none=True)\r\n    )\r\n    .where(\r\n        DBModel.number == db_record.number\r\n    )\r\n    .returning(DBModel.unique_id)\r\n)\r\n```\r\n\r\n2. Generated SQL statement\r\n```sql\r\nUPDATE\r\n  db_table\r\nSET\r\n  db_col.value = :db_schema_col_value\r\nWHERE\r\n  db_table.number = :db_schema_col_number\r\nRETURNING\r\n  db_table.unique_id\r\n``` \r\n\r\n3. Expected GoogleSQL statement\r\n_ref: https://cloud.google.com/spanner/docs/reference/standard-sql/dml-syntax#insert-and-then-return_\r\n```sql\r\nUPDATE\r\n  db_table\r\nSET\r\n  db_col.value = :db_schema_col_value\r\nWHERE\r\n  db_table.number = :db_schema_col_number\r\nTHEN RETURN\r\n  db_table.unique_id\r\n``` ","author":{"url":"https://github.com/caiopizzol","@type":"Person","name":"caiopizzol"},"datePublished":"2023-07-07T15:22:41.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/332/python-spanner-sqlalchemy/issues/332"}