Stonefield Query is a query builder and report writer tool from Stonefield Software Inc.. Stonefield Systems Group Inc. was incorporated in 1991. The company co-founders are Mickey Kupchyk CMA and Doug Hennig B.Sc. The founders had a vision: rather than build another database reporting tool geared towards IT

Information technology

Information technology is the acquisition, processing, storage and dissemination of vocal, pictorial, textual and numerical information by a microelectronics-based combination of computing and telecommunications...

 professionals they would design a user-friendly package targeted at the 99% of the population who weren’t technically inclined. They would take care of all the hard programming so that the end user could simply pick the information they wanted and it would automatically format the output. The reporting software had to work across multiple database application

Database application

A database application is a computer program whose primary purpose is entering and retrieving information from a computer-managed database. Early examples of database applications were accounting systems and airline reservations systems, such as SABRE, developed starting in 1957.A characteristic of...

s. In 1996 the first version of Stonefield Query was released.

There are custom versions of Stonefield Query available for GoldMine

GoldMine

GoldMine is a Customer Relationship Management software package, made by FrontRange Solutions. It is a Microsoft Windows program that manages client and prospect contact details as well as interactions with these contacts, such as calls made to and by the contact, emails sent and received and...

, ACT!, HEAT

Heat (software)

HEAT is a commercial help desk issue management software suite produced by FrontRange Solutions. According to FrontRange staff, HEAT stands for Helpdesk Expert Automation Tool.- Architecture :...

, SalesLogix, Account Mate, Alere, Sage Timberline Office, Sage Accpac ERP, Sage Pro ERP, Sage BusinessVision, Sage MAS 90/200, and SageCRM.

The Stonefield Query SDK allows the user to create a version of Stonefield Query for any database

Database

A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...

. The SDK is used to create the data dictionary

Data dictionary

A data dictionary, or metadata repository, as defined in the IBM Dictionary of Computing, is a "centralized repository of information about data such as meaning, relationships to other data, origin, usage, and format." The term may have one of several closely related meanings pertaining to...

, configuration, and script files for a database, whether it's native Visual FoxPro

Visual FoxPro

Visual FoxPro is a data-centric object-oriented and procedural programming language produced by Microsoft. It is derived from FoxPro which was developed by Fox Software beginning in 1984. Fox Technologies merged with Microsoft in 1992, after which the software acquired further features and the...

 tables (free or in a database container), SQL Server

Microsoft SQL Server

Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...

, Oracle

Oracle Database

The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....

, Access

Microsoft Access

Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of...

, DB2

IBM DB2

The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions...

, MySQL

MySQL

MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...

, dBase

DBASE

dBase II was the first widely used database management system for microcomputers. It was originally published by Ashton-Tate for CP/M, and later on ported to the Apple II and IBM PC under DOS...

, or any other ODBC

Open Database Connectivity

In computing, ODBC is a standard C interface for accessing database management systems . The designers of ODBC aimed to make it independent of database systems and operating systems...

-compliant database. It also works with any OLE DB

OLE DB

OLE DB is an API designed by Microsoft for accessing data from a variety of sources in an uniform manner. It is a set of interfaces implemented using the Component Object Model ; it is otherwise unrelated to OLE...

 provider, SQLXML

SQL/XML

SQL/XML or XML-Related Specifications is an extension to the Structured Query Language specification, which defines the use of XML in conjunction with SQL. The XML data type is introduced, as well as several routines, functions, and XML-to-SQL data type mappings to support manipulation and storage...

 [SQL Server access over HTTP], Web Services, and anything with an API

Application programming interface

An application programming interface is a source code based specification intended to be used as an interface by software components to communicate with each other...

 you can code against. It can even query against Microsoft Excel

Microsoft Excel

Microsoft Excel is a proprietary commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications...

 and text file

Text file

A text file is a kind of computer file that is structured as a sequence of lines of electronic text. A text file exists within a computer file system...

s.

Version 4.0 was released on July 13, 2010. This version has added new features, including output to Microsoft Excel Pivot Tables

Pivot table

In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, pivot-table tools can automatically sort, count, total or give the average of the data stored in one table or spreadsheet...

and support for "application views".

At the 2008 Account Mate Synergy conference, Stonefield Query won the Vertical Solution Partner Award for Innovative Integration.