Support the function of returning like pg
Open
compatibility-mariadb
type/compatibility
type/feature-request
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Feature Request
**Is your feature request related to a problem? Please describe:**
Atomic retrieval of deleted/update/insert updated records to avoid transactions and unnecessary select and reduce code complexity
**Describe the feature you'd like:**
e.g
```sql
INSERT INTO users (firstname, lastname) VALUES ('Joe', 'Cool') RETURNING id;
UPDATE table_name SET column1 = value1, ... WHERE condition RETURNING column1, column2, ...;
DELETE FROM table_name WHERE condition RETURNING column1, column2, ...;
```
**Describe alternatives you've considered:**
**Teachability, Documentation, Adoption, Migration Strategy:**
Contributor guide
Assessment
This issue has not been assessed yet.