Skip to main content

SQL Query Text

Create a query workload from the SQL text user input. User can input multiple statements separated by ";".

SQL Types

  • select
  • update
  • delete
  • insert ... select
  • merge
  • replace

Database Vendors

  • MySQL
  • PostgreSQL
  • Openguass
  • Maria(alpha)
  • Oracle(alpha)

Example SQL Query

select *
from customer
where c_custkey = (select max(o_custkey)
from orders
where subdate(o_orderdate, interval '1' DAY) < '2022-12-20')