Sql query builder


sql query builder Whenever I open "query builder" first time for a query, or af Visual SQL Query Builder for classic ASP. You can choose between two query builders: Tutorial: Add a Parameter to Select any data source that is type SQL When you add a query parameter to a query, Report Builder automatically creates a AQT Query Builder, graphical query builder, build SQL queries Based on the column dragged with condition applied a SQL query is generated at the has a decent-ish query builder. Build your SELECT queries with drag-and-drop ease. This application allows user to select MySQL database and when the “use” button is clicked, the program will then load all the tables existing from a specific database. Getting unformatted SQL Text Active Query Builder is a component intended to build SQL queries as well as to parse them and represent I don’t want to use long SQL strings in the code. As strange as it might be, my next post is going to be about how to get the query designer working in Generate dynamic SQL statements in SQL Server. You can also build a query in Query Builder and then add custom statements to the query. NET component that allows your end-users to build complex SQL queries through a highly visual and appealing GUI. Will be nice to know so I can code the rest in the Extension for Visual Studio - Query-Objects is a highly visual SQL query builder component that leverages on the power of . It allows the query to be built up and translates that to SQL against entities: Online HTML demo: full-featured data browsing UI built with Active Query Builder Web API. NET (Compatible with ASPX and Razor view engines, it supports MVC with partial views and Bootstrap). If you select multiple columns in two Introduction to the basic operators in the SQL Query Builder. This class can be used to dynamically build SQL database queries. NET MVC, Razor and ASPX view engines, Bootstrap compatible Online HTML demo: full-featured data browsing UI built with Active Query Builder Web API. Freeform SQL and Query Builder provide two alternative methods to access your data and begin analysis with MicroStrategy. $this->db->get_compiled_select()) but then choose to, SQL Query Builder for FileMaker provides a simple utility for writing and troubleshooting SQL queries. The Query Builder enables you to create a query without writing or editing SQL statements. Custom SQL Queries: Freeform SQL and Query Builder. Knex. Firstly, it is a pain to write long multiline strings in Object Pascal. Sql Query Builder Net Source Code Codes and Scripts Downloads Free. g. Creating joins in the SQL Query Builder. net using class or any other technique where i can drag drop tables and if they are having relatio In this tutorial, It covers how to create a simple MySQL query builder using Visual basic. Build SQL queries by drag and drop with any SQL knowledge - forget routine typing! Query Builder for SQL Server is a visual designer tool for convenient generation of complex SQL queries for MS SQL database. Query Builder. The DataFlux Query Builder enables you to build complex SQL Server queries using a query building interface. Net? [closed] Ask Question. Online visual query builder Online SQL Report Builder Create high-performing SQL code on major DBMSs from one interface Easily build complex SQL statements with visual query builder Quickly construct, analyze and execute SQL code with code analyst Simplify debugging SQL code, functions, and stored procedures Collaborate effectively across development I use Oracle SQL Developer (version 17. The goal of SuperQuaiL is to help Java developers who code SQL run and create queries easier. EasyQuery. 0 Using Query Builder in Oracle SQL Developer 3. 3. The following steps explain how. 0 Working with PL/SQL Bridging the gaps in your technology with our SQL query tool and reporting services that will take your data reporting to the next level. Use point-and-click, drag-and-drop, and query builder in Oracle SQL Developer. Building queries - Active Query Builder User's Guide Is there a dynamic Sql builder library for . A C# library which helps create customized and extensible sql queries more easily. js or in the browser. SQL) is always a challenge. Screenshots. I want to create a SQL Query Builder in C#. From PostgreSQL wiki. ObjectQuery also implements a set of query builder methods that can be used to sequentially construct query commands that are equivalent to Entity SQL. A powerful SQL tool to transform or reverse complex queries A graphical query builder that permits to create complex SQL queries easily. SQL query builder that doesn't make you learn SQL Visual SQL query builder tool for automatic query generation for SQL Server, MySQL, Salesforce, QuickBooks, SugarCRM, Dynamics CRM SQL query builder tool documentation, features, and information. You can then amend the SQL further or run it. Over the time it has been ranked as high as 1 458 599 in the world, while most of its traffic comes from USA, where it reached as high as 617 336 position. Here you will learn how SQL syntax works and the two ways you can write queries using the query builder. Tools like our SELECT Query Editor, utility query builder, and code builder tools, just to name a few, make editing MySQL queries easy. SQL query builder with human language interface. 1. Query-Objects is a highly visual SQL query builder component that leverages on the power of . Powerful Self-Service Business Intelligence Tools. SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql and PostgreSql Using Query Builder, you can search and filter database objects, select objects and columns, create relationships between objects, view formatted query results, and save queries with little or no SQL knowledge. 0 provides an intuitive report authoring environment for business as the report queries include the How to build queries with your mouse versus the keyboard. It is an Community Guide to PostgreSQL GUI Tools. Click Use a wizard. Really. It's a designer that helps you create Linq to Sql queries in your application. Query expressions are used in ArcGIS to select a subset of features and table records. In general (fortunately), you don’t need to understand any arcane technical language to write SQL queries that work. I have made a Query Builder, (not the full version of it yet) but I wanna ask if there is someone out there, there can improve this code even more. SphinxQL Query Builder for PHP. Easyquerybuilder. You no longer need to be a pro, or hire a database expert, to query your internal product databases. The powerful c# sql query builder. (Embarcadero, are you listening? Sql Query Builder Net Source Code Codes and Scripts Downloads Free. Use the Query Builder to specify a query that retrieves a result set to use in a paginated report. 56 - Create and manage SQL queries for your Microsoft SQL Server database environment with t MyQuery Builder is a visual browser-based MySQL query editor for PHP web developers that makes building MySQL queries easy. Dynamic SQL query builder will be a good addition for any Windows Forms application (especially a database-related one). Here's how to define a SubQuery WHERE clause in your SELECT statements. Need similar functionality on your own web-site? DbSchema database GUI has everything you need to design and query any SQL and DbSchema Diagram Designer and Admin Using the Visual Query Builder you will Paper 1557-2014 The Query Builder: The Swiss Army Knife of SAS SQL IN THE QUERY BUILDER SQL is a query language used by many software packages. Query Builder Class This is useful in situations where you are using Query Builder to generate SQL (ex. Even if you are familiar with SQL, the graphical interface makes it easier to create relationships and visualize the query. To use the Query Builder Tab, you need a good To build a filter using the Query Builder page on the defining queries using the SQL MyQuery Builder makes building and editing MySQL queries easy. There are three main parts of the GQB. Using SQL Developer, you can browse database objects, run SQL statements, edit and debug PL Import/Export This demo shows how SQL and MongoDB import/export features are working. NET data access to create data-driven WinForms and ASP. Free and safe download. The builder is divided in two parts. Command editor. 279) in Windows 10 64 bit. For example, you use this syntax using the Select By Attributes tool or with the Query Builder dialog box to set a layer definition query. | See more ideas about Bootstrap search form, Form builder and Dashboard ui. Query Builder Drag and drop Oracle SQL Developer 4. Both C# and VB projects are supported. I have tried a few things I have found, but none of them work like Access. Key features include: Visual Query Builder; Handy SQL Editor with code folding and syntax highlighting MyQuery Builder is a visual browser-based MySQL query editor for PHP web developers that makes building MySQL queries easy. Dynamic Query Builder The role of dynamic query builder is to assist you in creating dynamic sql queries. What is the SQL Query Builder? The SQL Query Builder (SQB) is a component of the Data Tools Platform (DTP) SQL Development Tools project. Advanced Query Builder is a powerful component suite for Delphi and C++ Builder intended for visual building SQL statements for the SELECT, INSERT, UPDATE and DELETE clauses. Active Query Builder, free and safe download. When implementing the Query Builder component, we refrained from the idea to allow end-users to modify their custom SQL queries since this would force us to implement a complex SQL parser for all supported database engine types (see Supported Data Sources). About SQL Query Builder. PostgreSQL Code Factory is a premier PostgreSQL GUI tool aimed at the SQL queries and scripts development. Introduction This tutorial explains how to create a dynamic LINQ query in C#. Looking for a business intelligence platform with a web based query builder that can perform any in which worksheets will create a single SQL query that can fully Query Builder is Business Objects administrator tool to query the metadata stored in the repository. Passport’s Query Builder™ is a software reporting tool that simplifies standard Microsoft SQL reporting. 0 The search condition will be displayed in your SQL statement in the Run SQL textbox. SQLeo Filters populated with values. . Titles include: Getting Started with Oracle SQL Developer 3. Jump to: navigation, search. Using Query Builder is an easy and convenient to build SQL statements in the Query window. • How to connect to your ArenaDB or ShelbyDB database inside SSMS. the different criteria for your queries; and perhaps different tables to query based on different conditions. As you will read it in this post, this project developed by interns is a prototype for a new kind of designers. About building an SQL expression: You use it in ArcMap to select features with the Select by Attributesdialog box or with the Query Builder dialog box to set a SQL is almost English; it’s made up largely of English words, put together into strings of words that sound similar to English sentences. I use Oracle SQL Developer (version 17. It includes graphical panes that display your SQL statement visually and a text pane that displays the text of your SQL statement. Visual Query Builder for building queries using the mouse. The MySQL SQL query builder allows users to build select, insert, update, and delete SQL statements easily. SQL Developer 3. Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. Key features include: Visual Query Builder; Handy SQL Editor with code folding and syntax highlighting The Query Builder tool, enables you to query the full CMS database and return meaningful results, d-encrypting its contents. SQL For those on the Toad board - the Query Builder is undergoing a complete rewrite and we're looking for users to hammer on it. Download; Buy Selecting Features by Attributes in ArcGIS ArcGIS only shows a small set of query operators you can use in the Query Builder. Include query-builder. NET apps. This is a SphinxQL Query Builder used to work with SphinxQL, a SQL dialect used with the Sphinx search engine. 0. This topic describes how to use the Query Builder to manage data tables and their relations in a Snap data model (e. sql query builder free download - dbForge Query Builder for SQL Server, FlySpeed SQL Query, EMS SQL Query for SQL Server, and many more programs PostgreSQL Code Factory is a premier PostgreSQL GUI tool aimed at the SQL queries and scripts development. Since the framework is still much in its infancy, I urge you to download, trial it and comment on it in the forums. SQL Maestro Group vendors powerful database management and web development tools for MySQL, Oracle, SQL Server, DB2, SQL Anywhere, PostgreSQL, SQLite, Firebird and MaxDB. 12. Background color per datasource. NET library demo pages. It is an Is there any free tools that would let me build queries like one MySQL query builder? i can advice you this tool Heidi SQL it very lightweight and also can Hi again guys , i hope you are remember me , Last week I opened here a support topic about create new report using sccm Query , some of you helped me proffesionally Find and save ideas about Sql query builder on Pinterest. I have fought with Access over SQL syntax that I write from scratch for use in Access VBA code Throw in the dot or bang issues and well Then it occured Active Query Builder is a query builder component suite for Borland Delphi / C++ Builder that allows your end-users to build complex SQL queries via an intuitive visual interface. 56 - Create and manage SQL queries for your Microsoft SQL Server database environment with t Active Query Builder is a query builder component suite for Borland Delphi / C++ Builder that allows your end-users to build complex SQL queries via an intuitive visual interface. Like for SQL Editor you can have multiple result panes. The tool requires a JDBC data adapter. When your language is SQL, the Query Builder is called the SQL Builder. The Query Builder is best used when you need to assemble a SQL statement procedurally, or based on some conditional logic in your application. Hi, I want to create a SQl builder on a form where i can directly drag and drop table names and if they What is the SQL Query Builder? The SQL Query Builder (SQB) is a component of the Data Tools Platform (DTP) SQL Development Tools project. Try the best online SQL Query Builder for free: Build SQL queries without SQL skills Generate charts, tables & dashboards within seconds Free Trial Use the Query Builder dialog box to create a query for use in the Execute SQL task, the OLE DB source and the OLE DB destination, and the Lookup transformation. Get the answer to "What is the best alternative to FlySpeed SQL Query?" Query builder is very intuitive and easy for designing very complex queries. For all Oracle SQL Developer 3. 0 Using Source Code Control in Oracle SQL Developer 3. Query Builder provides an easy way to quickly access your ODBC data sources without having to write any SQL. f Check Help under “SQL reference SQL Query Builder. By Sue Harper March/April 2008 I'm often asked to describe the difference between Easy Query Builder is a complete freeware solution for users who need to extract information from databases with as little effort and knowledge needed as possible. New to Oracle SQL Developer. Download SQLeo Visual Query Builder for free. Oracle SQL Developer has a visual query builder. Want to query your data but don't know SQL? Our powerful Query Builder tool can help you to build even complex queries visually via drag-and-drop without typing a line of code. Active Query Builder latest version: Allow end-users to build complex SQL queries via an intuitive interface. NET is a visual query designer, SQL parser and editor component for WinForms and ASP. Whenever I open "query builder" first time for a query, or af The Visual Linq query builder is a Visual Studio 2008 addin. Queries are used to select a subset of features and table records. Build queries with a web-based visual builder, and drag and drops tables. It's connected to an Oracle database in the network through TNS. The SQL Query Builder is a component for visually editing SQL DML statements. Microsoft SQL Server 2008 R2 Report Builder 3. Documentation GitHub Build Queries Visually. Learn how to execute database queries using the Laravel PHP Fluent Query Builder. All queries in ArcGIS use standard Structured Query Language (SQL). Free Download dbForge Query Builder for SQL Server 3. Laravel’s query builder offers a nice way to work with raw SQL. I have heard that there is a new version of Report Builder in SQL Problematic SQL Queries Microsoft SQL Server 2008 Report Builder 2. Suppose you are not SQL-guru but need to deal with databases - find some information, filter table(s) by parameters, build an SQL query touse it somewhere outside. Applies To: SQL Server 2016. Learn how to use SQL to store, query, and manipulate data. Customize your SQL queries: Query Builder. I can do some things in SQL, however, things like an update query with inner or outer joins still elude me. 0: Create a Query Using Query Builder Active Query Builder - Visual Query Builder for ASP. Today, we’re pleased to announce a long requested feature from the SQL Server Reporting Services community. , to create master-detail data sources), filter incoming data and specify a custom SQL string. SQL Query Builder give s you the ability to u se the simple graphical interface to build SQL statements and create views in a database. com is tracked by us since August, 2014. Download the latest version of the top software, games, programs and apps in 2018. FlySpeed SQL Query - a database SQL query tool for different database servers to get access and work data with ease. Result . Learn more about and get access to our innovative FileMaker SQL builder, developed by certified and experienced FileMaker developers. EasyQuery WinForms is designed to help you with this task. Metadata explorer. Using Query Builder, you can search and filter database objects, select objects and columns, create relationships between objects, view formatted query results, and save Doctrine Database Abstraction Layer Documentation: SQL Query Builder Download a trial version of dbForge Query Builder for SQL Server and evaluate it for free during 30 days. System DB2 RazorSQL Query Builder with what is db2, install db2, db2 instances, db2 database, create database, activate database, deactivate database, connect to database, verify database, configure database manager, drop database, db2 bufferpool, drop bufferpool, db2 tables, create tables, list tables, insert data in table, db2 alias, db2 constraints This tutorial teaches you how to create and run a DB2 SQL query. I have been trying by best to create a definition query which would select a group of municipalities from among the many in my state. GUI Query Builder. It works with local and client-server databases. You can use the SQL Query Builder to define the join conditions. Leverage the Active Query Builder SQL interface builder and the ease of . You can preview the data before importing it into a data table. With the latest releases of Report Builder and SQL Server Data Tools – Release Candidate, you now have the ability to create native DAX queries against supported SQL Server Analysis Hi, I want to create a SQl builder on a form where i can directly drag and drop table names and if they Introduction. SQLeo is a professional lightweight SQL Query tool that permits to create or display complex sql queries (from OBIEE, Microstrategy, SSRS, Cognos, Hyperion, Pentaho ) and permits to reverse engineer database models as db designers do. Hi I've just started using SQL Report Builder to try and design some reports for work but have come across an issue, basically the report focuses on 2014 by DbQwikEdit is a SQL tool for all databases. Visual Query Builder. SQL, and how to best use FlySpeed SQL Query is an easy-to-learn-and-operate graphical tool to build queries on different database servers without needing deep knowledge of SQL syntax. The DbVisualizer Query Builder provides an easy way to develop database queries, using a point-and-click interface that does not require in-depth knowledge of the SQL syntax. 0 to Build Queries Visually. SqlBuilder. Using the SQL Query Builder, which is a visual interface for creating and running SQL queries, you will build a SELECT statement. User-friendly ad-hoc query builder for your ASP. 0 OBE, see the Oracle SQL Developer 3. DB2 RazorSQL Query Builder with what is db2, install db2, db2 instances, db2 database, create database, activate database, deactivate database, connect to database, verify database, configure database manager, drop database, db2 bufferpool, drop bufferpool, db2 tables, create tables, list tables, insert data in table, db2 alias, db2 constraints Download Sql Query Builder . • How to use the Query Builder tool SQL Server Management Studio with SQL queries the SuperQuaiL is a Java SQL query builder. Easy Query Builder Freeware - Design SQL queries with ease I realize this is only "loosely" related to SQL Server (and I'll be cross-posting to an Excel forum) butanyone out there have any experience/recommendations for an inexpensive/free GUI query builder tool primarily for use against SQL Server 2005/2000? Hi All, I have successfully installed ODBC client Driver on my MAC server machine to be able to import from a FM DB to itself on FM server. Visual SQL Query Builder for Desktop apps and Web sites to Get Data from SQL Databases Fast & Safe. Using Query Builder, you can search and filter database objects, select objects and columns, create relationships between objects, view formatted query results, and save Laravel's database query builder provides a convenient, fluent interface to creating and running database queries. Using one programming language (Java) to generate code for another language (i. NET and MVC environemnts, Razor and ASPX view engines, with full support of all popular database servers and appropriate SQL dialects. Find info about repository, users, universes, reports and other objects Download Sql Query Builder . SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. It can be used to perform most database operations in your application and works on all supported database systems. SelectQueryBuilder: Building complex and flexible SQL queries/commands from can i create sql query in query builder by selecting sql views instead of selecting Query Builder enables you to interactively create SQL queries without writing SQL statements. Click and select the table in the data source that contains the fields you want to query with SQL and import into your Excel spreadsheet. 0: Create a Query Using Query Builder Overview. Try the best MySQL Query Builder: Generate MySQL queries with a few clicks Build charts and tables by drag & drop Automated reports Free Trial After that, Active Query Builder generates a new SQL query according to that model, so only valid SQL queries with correctly quoted literals can be generated in the end. Click the image to enlarge it. Featuring Visual Query Builder, Syntax Builder, Table Data Editor, Data Mover, data export, data publishing. Using the Predicate Builder we can create LINQ to SQL dynamic query and Query with Entity Framework is easy. Query Builder's graphical user interface enables database developers to build SQL queries without the need for manual SQL coding. Query Builder is the preferred method for selecting and importing data from a SQL database without writing SQL statements. I have tried commands of all sorts of variations from "Name"=' SQL Script Builder is free software that create a database migration sql script (or dump file) from any ODBC data source. Running queries and exporting result to Excel and CSV. SQL Query Builder can be used to dynamically build SQL database queries. Query expressions in ArcGIS adhere to standard SQL expressions. Squel is a compact, lightweight Javascript library for building SQL query strings, usable with node. Let’s see some examples where we can use raw SQL to implement custom logic for ordering the results Explore 25 apps like SQLeo Visual Query Builder, Free tool to work with SQL queries and data that suitable for different database servers and desktop databases. js after the dependencies. </> See source Query Builder's graphical user interface enables database developers to build SQL queries without the need for manual SQL coding. You can use Query Builder to perform the following tasks: Working with a graphical representation of a query or with SQL commands Query Try the best online SQL Query Builder for free: Build SQL queries without SQL skills Generate charts, tables & dashboards within seconds Free Trial If you don’t know how to write SQL Queries or if you find it difficult to perform grouping, sorting and join operations then you can use SQL Query Builder Online SQL query builder for Oracle, SQL Server, Postgres, MySQL, Redshift, Greenplum and other databases. The Visual Linq query builder is a Visual Studio 2008 addin. It provides functions for defining query parameters such as the query type, tables, columns, the clauses where, order by, group by and having, limit row range. The Query Builder can be used from within any editor to create or modify select statements. Extension for Visual Studio - A Visual WinForms control to build complex SQL queries via an intuitive interface, as well as to parse, modify, and analyze them. No need to know SQL reporting tool commands. It can be consumed by other UI components such as editors, dialogs and wizards. The Laravel query builder uses PDO parameter binding to protect your This tutorial shows you how to use the Query Builder feature in Oracle SQL Developer 3. SQLeo. CMS Query Builder is a tool for building CMS queries, running them against the database and exporting the result to excel spreadsheet. By Sue Harper March/April 2008 I'm often asked to describe the difference between To get started use the controls below or pick one of the pre-defined searches here: RedQueryBuilder I can do some things in SQL, however, things like an update query with inner or outer joins still elude me. This topic Query-Objects visual SQL query builder component is a top-notch WPF . 0 OBE Series in the Oracle Learning Library. SQL Visual Query Builder. For the relatively simple three-table inner join SELECT queries I needed, I was able to write correct LINQ syntax myself with only a database diagram, IntelliSense and online help for guidance. English| Russian SQL. Key to success is putting in the effort to Download FreeQueryBuilder for free. Simply drag tables and views from the Object Browser on the left, and drop them into the work area on the right. Start analyzing, managing your SQL, NoSQL databases most quickly and efficiently with the help of BI Platform, DBHawk Online SQL Editor, SQL Query Builder, Ad-Hoc SQL Report Builder, SQL Charts & SQL dashboard builder. DataFlux Data Management Studio 2. SQL Query Builder enables By adding the following code below to your website you will be able to add an install button for SQL Development Tools. Anyone knows some good SQL builder library for Java like Squiggle Is there any good dynamic SQL builder library in Java? Sql query builder c# for windows Try the best MySQL Query Builder: Generate MySQL queries with a few clicks Build charts and tables by drag & drop Automated reports Free Trial EasyQuery WinForms. Graphical Query builder¶. The script produced will migrate all or part of database. Query Builder enables you to interactively create SQL queries without writing SQL statements. SQL queries sent to CMS database, Active Query Builder for . Helping users to quickly understand SQL queries. 5: User Guide. The Graphical Query Builder (GQB) is part of the Query Tool which allows you to build simple SQL queries visually. NET version 4 Build Queries Visually. Get yours today! How to enable Query Designer for SQL Server in Visual Studio. FastQueryBuilder is an easy to use visual SQL query builder. We can use them in our where conditions and also in our orderings as well. Get our complimentary SQL Query Builder here. As I was testing the LINQ to SQL functionality in Visual Studio 2008, I found myself missing the SQL Query Builder. Overview. Supports Oracle, MySQL, Access, MS SQL, Fox Pro, DBase, Paradox and more via ADO. FreeQueryBuilder a java tool that allow you to create SQL queries without directly writing SQL. (Embarcadero, are you listening? Getting unformatted SQL Text Active Query Builder is a component intended to build SQL queries as well as to parse them and represent This class can be used to dynamically build SQL database queries. How can I make a query builder into window application. css in your page head and query-builder. For other output formats like SQL and MongoDB, please refer to the The ObjectQuery class supports both LINQ to Entities and Entity SQL queries against a conceptual model. With the latest releases of Report Builder and SQL Server Data Tools – Release Candidate, you now have the ability to create native DAX queries against supported SQL Server Analysis To get started use the controls below or pick one of the pre-defined searches here: RedQueryBuilder Hi, I want to create a SQl builder on a form where i can directly drag and drop table names and if they I don’t want to use long SQL strings in the code. You can access the Query Builder in the data source test step window, below the SQL Query box. --Using the SQL Query Builder, can you treat two or more queries as a saved database PROJECT? In other words, (similar to MS Access), can you build smaller queries and then use those queries as sub queries WITHIN the saved Oracle database project to build a master/final Extract data and models from Oracle, SQL Server, MySQL, PostgreSQL, SQLite, Firebird, Sybase, Ingres, DB2, with no SQL knowledge. Connections and Join Query builder. NET - is a component library that allows you to integrate user-friendly . e. Hello Adam, Allow me to follow-up with you on this. SqlBuilder is a library which attempts to take the pain out of generating SQL queries within Java programs. js is a "batteries included" SQL query builder for Postgres, MSSQL, MySQL, MariaDB, SQLite3, Oracle, and Amazon Redshift designed to be flexible, portable, and fun to use. NET web-site. MyQuery Builder is a visual browser-based MySQL query editor for PHP web developers that makes building MySQL queries easy. sql query builder