An SQL statement looks something like this: "select customer_name, ship_date from orders where product_id=17 and state='CA'." There are two things to notice here. First, SQL has a simple, English ...

SQL SELECT statement. The SELECT statement tells the query optimizer what data to return, ... Java, or R, you’re going to use the functions and syntax of those procedural languages.

Queries that return data (i.e. SELECT statements) return a SQLResults object. The SQLResults object maps the fields from the query to simple Java objects and provides access methods such as getInt(), ...