Command sql result in datatable - Javascript client

Data Abstract
1

I have a command on schema defined as :
statement type = stSQL
SQL = SELECT col1, col2 FROM tbl1 ORDER BY col1

How can I obtain on Javascript client the result of this command in a data table? Could you please make an example?
Thanks

2

Looks like it’s not a recommended way (or even impossible). Are there any significant reasons to use command instead of table?

3

Thanks