updated API
updated compiled code
added getSQL function to command list