{"capability":{"Key":"writable-with-queries-common-table-expressions","SourceKind":"yaml","SourceDatabase":"center","SourceTable":"featurematrix.yaml","SourceKey":"Writable WITH Queries (Common Table Expressions)","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","Name":"Writable WITH Queries (Common Table Expressions)","NameLocale":"en","GroupKey":"sql","GroupName":"SQL","GroupLocale":"en","Ordinal":26,"GroupOrder":3,"Facts":{"feature":{"description":"Allows INSERT/UPDATE/DELETE in WITH clauses which can be used in conjunction with a RETURNING clause to to pass data up to the containing query.","name":"Writable WITH Queries (Common Table Expressions)","versions":{"9.1":"Yes"}},"group":"SQL","versions":{"max":18,"min":8.1}},"Cells":[{"Version":"10","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"11","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"12","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"13","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"14","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"15","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"16","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"17","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"8.1","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.2","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.3","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.4","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.0","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.1","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"9.2","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"9.3","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"9.4","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"9.5","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},{"Version":"9.6","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"}],"Texts":[{"Locale":"en","Title":"Writable WITH Queries (Common Table Expressions)","BodyHTML":"\u003cp\u003eAllows INSERT/UPDATE/DELETE in WITH clauses which can be used in conjunction with a RETURNING clause to to pass data up to the containing query.\u003c/p\u003e\n","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","ContentHash":"30b71af09b17f22dca1896593a051442f4106552a761fca60d6f2ae794e20667","Payload":{"description":"Allows INSERT/UPDATE/DELETE in WITH clauses which can be used in conjunction with a RETURNING clause to to pass data up to the containing query.","name":"Writable WITH Queries (Common Table Expressions)","versions":{"9.1":"Yes"}}},{"Locale":"zh-Hans","Title":"可写 WITH 查询 (公用表表达式)","BodyHTML":"\u003cp\u003e允许在 WITH 子句中使用 INSERT/UPDATE/DELETE，这些语句可以与 RETURNING 子句结合使用，将数据传递给包含查询。\u003c/p\u003e\n","SourceHash":"071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50","ContentHash":"5fe899b788127e6bded1060ebe62a4f8ab4be083e6a7f40457225387fa92d6f2","Payload":{"description":"允许在 WITH 子句中使用 INSERT/UPDATE/DELETE，这些语句可以与 RETURNING 子句结合使用，将数据传递给包含查询。","name":"可写 WITH 查询 (公用表表达式)"}}],"GroupTitles":{"en":"SQL","zh-Hans":"SQL"},"LegacyIDs":["208"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.1","Supported":true,"Original":"Yes"},"selected_version":"18"}