3. Translating PGQL queries to SQL

The following classes can be used to translate the underlying PGQL query into the corresponding SQL query.

class opg4py.pgql.PgqlSqlTrans(java_pgql_sql_trans)

Wrapper class for oracle.pg.rdbms.pgql.PgqlSqlTrans

get_translation_type()

Get the type for the PGQL to SQL translation.

Returns

a PgqlSqlTrans.TranslationType object with the SQL translation type

class opg4py.pgql.PgqlSqlQueryTrans(java_pgql_sql_query_trans)

Wrapper class for oracle.pg.rdbms.pgql.PgqlSqlQueryTrans

get_return_types()

Get an array of column descriptors for the result columns in the query result.

Returns

result column descriptions

get_sql_bv_list()

Get a list of Bind Values to be used with this SQL translation. The first element in the list should set at position 1 in a JDBC PreparedStatement created from this SQL translation.

Returns

the list of bind values for this query translation

get_sql_translation()

Get the SQL string for the PGQL to SQL translation.

Returns

the SQL query string