Another feature of note is the inclusion of the Data Tools Platform SQL Query Builder(SQB) prototype, which allows queries to be built graphically. 另一项需要注意的功能是引入DataToolsPlatformSQLQueryBuilder原型,这将允许图形化构建查询。
On closing the Query Builder, the SQL code in the Query Builder is automatically pasted in the editor at the insertion point. 在关闭QueryBuilder时,QueryBuilder中的SQL代码被自动粘帖到编辑器的插入点中。
Support for SQL / XML functions in query builder 在查询构建器中支持SQL/XML函数
You can now specify your parameters by changing the SQL statement in the query text box or by clicking query builder. 现在,可以通过更改“查询文本”框中的sql语句或单击“查询生成器”来指定参数。
Depending upon your choice of SQL Builder or SQL Editor option, the IDE will either open a query builder wizard or an SQL editor to build the required query. 根据您选择的SQLBuilder或SQLEditor选项,IDE将打开一个查询构建器向导或一个SQL编辑器来构建所需的查询。