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_sql_bv_list()

Get a list of Bind Values to be used with this SQL translation.

The first element in the list should be set at position 1 in a JDBC PreparedStatement created from this SQL translation.

get_sql_translation()

Get the SQL string for the PGQL to SQL translation.