Data Operations
Data CRUD operations
Query Records
Query data in table, supports complex queries, join queries, pagination, sorting, etc.
Count Data Records
Count data records in table that match conditions
Insert or Upsert Records
Insert single or multiple records, supports upsert operation
Update Records
Update data according to conditions, WHERE conditions must be provided
Delete Records
Delete data according to conditions, WHERE conditions must be provided
Query Records with Schema
Query data from tables in specified database
Insert Records with Schema
Insert data into tables of specified database
Update Records with Schema
Update data in tables of specified database
Delete Records with Schema
Delete data from tables in the specified database
Query Records with Instance and Schema
Query data from tables in the specified instance and database
Insert Records with Instance and Schema
Insert data into tables of the specified instance and database
Update Records with Instance and Schema
Update data in tables of the specified instance and database
Delete Records with Instance and Schema
Delete data from tables in the specified instance and database