This package can run common SQL queries on a given database table.
It can connect to a database server using PDO with connection parameters read from environment variables.
The package executes SQL queries on a table using parameter values. Currently, it can:
- Get all values from a table column that match a given condition
- Get all values from the table that match a given condition
- Get all values from the table sorted by a random order
- Get all values from the table that match a condition using prepared queries to define the condition parameter values
- Insert records in the table using the given column values
- Delete records from the table that match a given condition
- Update the records from the table that match a given condition |