Query a Table

Executes a SQL query on a table and returns the result.

Overview

This procedure executes a SQL query on a table and returns the result.

Input Concepts

Concept	Type	Description	Default	Required
table	table	The table to be queried.	No default	Yes
sql query	string	The SQL query to execute on the table, enclosed in quotes. [SQLite syntax]	No default	Yes

Output Concepts

Concept	Description
table	The resulting table after executing the SQL query.

Examples

1. Query a Sample Table

Automation

create a sample table
query the table with
    the sql query is "SELECT Name, Number, UPPER(Address) AS Address, REPLACE(REPLACE(City, 'San', 'SFO'), 'Jose', 'JOS') AS City FROM sample table"

Results

Name	Number	Address	City
John	[phone]	123 EAST STREET	SFO Francisco
Joe	[phone]	321 WEST STREET	SFO JOS
Jack	[phone]	213 NORTH STREET	SFO Francisco