Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- input: |-
UPDATE t_generated as t SET t."b" = 1 WHERE a = 1;
UPDATE t_generated as t SET t."b" = 2 WHERE a = 2;
UPDATE t_generated as t SET t."b" = 3 WHERE a = 3;
UPDATE t_generated as t SET t."b" = 4 WHERE a = 4;
UPDATE t_generated as t SET t."b" = 5 WHERE a = 5;
UPDATE t_generated as t SET t."b" = 6 WHERE a = 6;
UPDATE t_generated as t SET t."b" = 7 WHERE a = 7;
backupdatabase: bbarchive
backuptable: prefix_t_generated
originaldatabase: db
originaltable: t_generated
result: |-
/*
Original SQL:
UPDATE t_generated as t SET t."b" = 1 WHERE a = 1;
UPDATE t_generated as t SET t."b" = 2 WHERE a = 2;
UPDATE t_generated as t SET t."b" = 3 WHERE a = 3;
UPDATE t_generated as t SET t."b" = 4 WHERE a = 4;
UPDATE t_generated as t SET t."b" = 5 WHERE a = 5;
UPDATE t_generated as t SET t."b" = 6 WHERE a = 6;
UPDATE t_generated as t SET t."b" = 7 WHERE a = 7
*/
INSERT INTO "public"."t_generated" ("a", "b") SELECT "a", "b" FROM "bbarchive"."prefix_t_generated" ON CONFLICT ON CONSTRAINT "t_generated_uk" DO UPDATE SET "b" = EXCLUDED."b";
- input: |-
UPDATE t_generated as t SET t."a" = 1 WHERE b = 1;
UPDATE t_generated as t SET t."a" = 2 WHERE b = 2;
UPDATE t_generated as t SET t."a" = 3 WHERE b = 3;
UPDATE t_generated as t SET t."a" = 4 WHERE b = 4;
UPDATE t_generated as t SET t."a" = 5 WHERE b = 5;
UPDATE t_generated as t SET t."a" = 6 WHERE b = 6;
UPDATE t_generated as t SET t."a" = 7 WHERE b = 7;
backupdatabase: bbarchive
backuptable: prefix_t_generated
originaldatabase: db
originaltable: t_generated
result: |-
/*
Original SQL:
UPDATE t_generated as t SET t."a" = 1 WHERE b = 1;
UPDATE t_generated as t SET t."a" = 2 WHERE b = 2;
UPDATE t_generated as t SET t."a" = 3 WHERE b = 3;
UPDATE t_generated as t SET t."a" = 4 WHERE b = 4;
UPDATE t_generated as t SET t."a" = 5 WHERE b = 5;
UPDATE t_generated as t SET t."a" = 6 WHERE b = 6;
UPDATE t_generated as t SET t."a" = 7 WHERE b = 7
*/
INSERT INTO "public"."t_generated" ("a", "b") SELECT "a", "b" FROM "bbarchive"."prefix_t_generated" ON CONFLICT ON CONSTRAINT "t_generated_pk" DO UPDATE SET "a" = EXCLUDED."a";
- input: |-
UPDATE t_generated SET A = 1 WHERE b = 1;
UPDATE t_generated SET A = 2 WHERE b = 2;
UPDATE t_generated SET A = 3 WHERE b = 3;
UPDATE t_generated SET A = 4 WHERE b = 4;
UPDATE t_generated SET A = 5 WHERE b = 5;
UPDATE t_generated SET A = 6 WHERE b = 6;
UPDATE t_generated SET A = 7 WHERE b = 7;
backupdatabase: bbarchive
backuptable: prefix_t_generated
originaldatabase: db
originaltable: t_generated
result: |-
/*
Original SQL:
UPDATE t_generated SET A = 1 WHERE b = 1;
UPDATE t_generated SET A = 2 WHERE b = 2;
UPDATE t_generated SET A = 3 WHERE b = 3;
UPDATE t_generated SET A = 4 WHERE b = 4;
UPDATE t_generated SET A = 5 WHERE b = 5;
UPDATE t_generated SET A = 6 WHERE b = 6;
UPDATE t_generated SET A = 7 WHERE b = 7
*/
INSERT INTO "public"."t_generated" ("a", "b") SELECT "a", "b" FROM "bbarchive"."prefix_t_generated" ON CONFLICT ON CONSTRAINT "t_generated_pk" DO UPDATE SET "a" = EXCLUDED."a";
- input: DELETE FROM t_generated where a = 1;
backupdatabase: bbarchive
backuptable: prefix_1_t_generated
originaldatabase: db
originaltable: t_generated
result: |-
/*
Original SQL:
DELETE FROM t_generated where a = 1
*/
INSERT INTO "public"."t_generated" ("a", "b") SELECT "a", "b" FROM "bbarchive"."prefix_1_t_generated";
- input: UPDATE t_generated SET a = 1 WHERE a = 2;
backupdatabase: bbarchive
backuptable: prefix_1_t_generated
originaldatabase: db
originaltable: t_generated
result: |-
/*
Original SQL:
UPDATE t_generated SET a = 1 WHERE a = 2
*/
INSERT INTO "public"."t_generated" ("a", "b") SELECT "a", "b" FROM "bbarchive"."prefix_1_t_generated" ON CONFLICT ON CONSTRAINT "t_generated_pk" DO UPDATE SET "a" = EXCLUDED."a";
- input: UPDATE test x SET x.c = 1 WHERE x.a = 1;
backupdatabase: bbarchive
backuptable: prefix_1_test
originaldatabase: db
originaltable: test
result: |-
/*
Original SQL:
UPDATE test x SET x.c = 1 WHERE x.a = 1
*/
INSERT INTO "public"."test" ("a", "b", "c") SELECT "a", "b", "c" FROM "bbarchive"."prefix_1_test" ON CONFLICT ON CONSTRAINT "test_pk" DO UPDATE SET "c" = EXCLUDED."c";
- input: UPDATE test SET c = 1 WHERE a = 1;
backupdatabase: bbarchive
backuptable: prefix_1_test
originaldatabase: db
originaltable: test
result: |-
/*
Original SQL:
UPDATE test SET c = 1 WHERE a = 1
*/
INSERT INTO "public"."test" ("a", "b", "c") SELECT "a", "b", "c" FROM "bbarchive"."prefix_1_test" ON CONFLICT ON CONSTRAINT "test_pk" DO UPDATE SET "c" = EXCLUDED."c";
- input: |-
SET ROLE admin;
UPDATE test SET c = 1 WHERE a = 1;
backupdatabase: bbarchive
backuptable: prefix_1_test
originaldatabase: db
originaltable: test
result: |-
SET ROLE admin;
/*
Original SQL:
UPDATE test SET c = 1 WHERE a = 1
*/
INSERT INTO "public"."test" ("a", "b", "c") SELECT "a", "b", "c" FROM "bbarchive"."prefix_1_test" ON CONFLICT ON CONSTRAINT "test_pk" DO UPDATE SET "c" = EXCLUDED."c";
- input: |-
SET search_path = myschema, public;
DELETE FROM test WHERE a = 1;
backupdatabase: bbarchive
backuptable: prefix_1_test
originaldatabase: db
originaltable: test
result: |-
SET search_path = myschema, public;
/*
Original SQL:
DELETE FROM test WHERE a = 1
*/
INSERT INTO "public"."test" ("a", "b", "c") SELECT "a", "b", "c" FROM "bbarchive"."prefix_1_test";