add sql column allocation test
improve sql condition test
update validate tests
improve template tests