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.
- 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