Method and system for operating on database queries

摘要

The present disclosure involves systems, software, and computer implemented methods for operating on database queries. One example method includes identifying a parameterized input query in a first database query language. The parameterized input query includes one or more parameter placeholders. A random value is generated, for each parameter placeholder. A concrete instance of the parameterized input query in the first database query language is constructed. The concrete instance of the parameterized input query replaces each parameter placeholder with the corresponding generated random value. A translated output query in a second database query language is generated, from the concrete instance of the parameterized input query. The translated output query includes the generated random values. Each of the generated random values are replaced within the translated output query in the second database query language with a placeholder value associated with the second database query language.

主权项

1. A method of operating on database queries, comprising:
identifying a parameterized input query in a first database query language, wherein the parameterized input query includes one or more parameter placeholders, each parameter placeholder defining a parameter name and a declared parameter type; generating, for each parameter placeholder in the parameterized input query in the first database query language, a random value of the declared parameter type; constructing a concrete instance of the parameterized input query in the first database query language, where the concrete instance of the parameterized input query replaces each parameter placeholder with the corresponding generated random value of the declared parameter type; generating, from the concrete instance of the parameterized input query in the first database query language, a translated output query in a second database query language different from the first query language, the translated output query including the generated random value of the declared parameter type; and replacing the generated random values within the translated output query in the second database query language with a placeholder value associated with the second database query language.