update sql: remove default value for as.
Merge pull request #517 from forumbyr/master

update sql: remove default value for as.