Get Record
Get Record is used to retrieve a single record from a database table using a
single field to search by.
Query All Records
Query All Records is used to retrieve records based on a search, or all
records from a database table.
Database Transaction
Database Transaction is used to perform a database transaction, which is a set
of operations that are executed as a single unit. If any database operation
fails, the entire transaction will be rolled back.
Direct Database Query
Direct Database Query is used to execute SQL queries, which is a query that is
executed directly against the database.
Add Record
Add Record is used to add a new record to a database table.
Add Or Edit Record
Add Or Edit Record is used to search for a record by a single field, and edit
it if it exists, or add it if it doesn’t.
Edit Record
Edit Record is used to edit an existing record in a database table.
Delete Record
Delete Record is used to delete an existing record from a database table.
Patch Record
Patch Record is used to patch an existing record in a database table.
Bulk Operations
Bulk Operations are used to perform bulk operations on a database table, such
as adding or editing multiple records at once.
Clear All Records
Clear All Records is used to clear all records from a database table.
External Database Query
External Database Query is used to perform a query against an external
database. This is useful for connecting to PostgreSQL, MS SQL, Oracle, or
MySQL.