Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- statement: |
CREATE TABLE book(id INT);
INSERT INTO book(id) values (1);
- statement: |
CREATE TABLE book(id INT);
SELECT id FROM book;
want:
- status: 2
code: 202
title: STATEMENT_WHERE_REQUIRE_SELECT
content: '"SELECT id FROM book;" requires WHERE clause'
startposition:
line: 2
column: 0
endposition: null
- statement: |
CREATE TABLE book(id INT);
SELECT id FROM book WHERE id > 0;
- statement: |
CREATE TABLE book(id INT);
(SELECT id FROM book);
want:
- status: 2
code: 202
title: STATEMENT_WHERE_REQUIRE_SELECT
content: '"(SELECT id FROM book);" requires WHERE clause'
startposition:
line: 2
column: 0
endposition: null
- statement: |
CREATE TABLE book(id INT);
SELECT id
FROM book
WHERE id > (
SELECT max(id)
FROM book
);
want:
- status: 2
code: 202
title: STATEMENT_WHERE_REQUIRE_SELECT
content: |-
"SELECT id
FROM book
WHERE id > (
SELECT max(id)
FROM book
);" requires WHERE clause
startposition:
line: 5
column: 0
endposition: null
- statement: |
SELECT CURDATE();