Skyvia Query Builder Review

Skyvia Query Builder is a comprehensive and easy-to-navigate tool for query building. With it, you can host data and build visual queries simply by dragging and dropping data entries. The tool boasts of being intuitive and easy-to-use, meaning, you do not need an in-depth understanding of SQL to execute functions and actions within the platform.

Easy data aggregation and function inputting

It only takes a click to apply data aggregations with the software. Users can simply choose a field of data and apply necessary aggregation functions. The resulting data is automatically sorted by non-sorted fields.

Seamless data joining and sorting

In just a matter of seconds, you can use various type-specific SQL functions on selected fields of data. The software also gives you access to additional data categories. Time or date fields, for instance, can be aggregated into day, months, or years, whichever you prefer.

Likewise, the Query Builder makes it possible for you to join related tables or data automatically. You no longer have to think about data logic and structure to make sense of relations in your data sets. The software takes care of that.

The tool also lets you drag fields to the sort field area to sort results according to that field’s logic. Altering sort orders is possible, and you can apply this to as many fields as you want.

Handy SQL editing

Skyvia gives you an EQL editor that you can use to enter SQL statements and apply it to the corresponding connection. Simply drag a table or a set of fields using the Connections Object List, and a resulting SELECT statement will be produced immediately.

Multiple options for viewing

The tool displays queries in three views: Builder, SQL, and Data View. With the Builder View, users can build a SELECT statement visually using the Query Builder tool. It shows the Query Builder and Results pane automatically. The SQL view, on the other, hand, lets you type and input SQL statements directly into the platform. The Data view is more precise, as it gives you the necessary space to list all query results. Once you have designed a query, you can use this view to have a comprehensive overview of your returned data.

Easily-accessible database of common and useful queries

Users no longer have to worry about painstakingly retrieving an SQL query for present data entries. The software makes it possible for you to access a Query Gallery where it lists all the queries you used. You can even access these queries on the go and edit it as you please.

To assist you in easily retrieving from a large plethora of queries, Skyvia makes it possible for you to find queries by data source, connection, query name, and more.

Effortless filter configuration

With the Query Builder, users can access type-specific filter editors for various field types. String fields can be easily configured and the platform list and filters data effortlessly. It also has capabilities for detailed value selection, as well as null/not null, equal/not-equal filters.

If you are worried about limitations in the number of filters, the software lets you create as many filters as you want to and form filter groups from such. These filter groups consist of filters and subgroups, embedded with logical operators. The software helps you form the most complex filter conditions there is.