Is there a DDL/DML statement auto checking tool?

As a DBA, beforing applying DDL/DML statement writing by developers to online database, I have to analyse and check potentail limits or danger in these statements,such as:

1.weather a "create table" statement contains a primary key

2.weather a "create table" statement's primary key is integer type

3.weather a "create table" statement having too many index

4.weather an "update" statement contains a where condition

.............

If there is a checking tool, these simple checking steps could be automatic~