Even better, prototyping reports with SQL is easy — you run your prototype report, and if the results aren't what you need, you tweak the SQL query or write a new query, and try again.

甚至用SQL生成报告原型也很容易——运行原型报告，如果结果不是所需要的结果，那么可以修改SQL查询或者编写新的查询，然后再试一试。

youdao

Now, when the same query is run, the native SQL that is generated is a single select statement joining the two tables from the different catalogs at the database tier as shown in Illustration 10.

现在，当同一个查询运行时，生成的原生s QL是单个选择语句，在语句在数据库层联接来自不同目录的两个表，如图10所示。

youdao

The only new key in this options array is the SQL key, which defines the inner SQL query to run in order to populate the element.

此选项数组中的惟一新键为sql键，它定义了运行内部sql查询以填充元素。

youdao