What is KSearch?

KSearch is a library that will help you build different types of SQL statements and manipulate the extracted data in a simple and intuitive way.

It is developed exclusively for Spring Boot and currently support only PostgreSQL database.

The supported SQL statements are:

SELECT statement

KSearch supports all clause associated to SELECT statement.
With KSearch you can:

• Query one and only one record from the database
• Query multiple database records.
• Automatically map the returned columns into an object with defined attributes.

INSERT statement

KSearch supports all clause associated to INSERT statement.
With KSearch you can:

• Insert a single record, as well as insert multiple records at the same time.
• Automatically map the columns returned into an object with defined attributes.
• Create statements of the type INSERT INTO and INSERT INTO SELECT.
• Know the number of records inserted.
• Control what to do in case of conflicts (Upsert available)

UPDATE statement

KSearch supports all clause associated to UPDATE statement.
With KSearch you can:

• Update records on a table.
• Automatically map the columns returned into an object with defined attributes.
• Execute an UPDATE statement that simulates working through a JOIN of the main table with another table using the FROM clause.
• Know the number of records updated.
• Add optional conditions (If value is null, condition is omitted automatically).

DELETE statement

KSearch supports all clause associated to DELETE statement.
With KSearch you can:

• Delete records on a table.
• Automatically map the columns returned into an object with defined attributes.
• Execute a DELETE statement that simulates working through a JOIN of the main table with another table using the USING clause.
• Know the number of records deleted.
• Add optional conditions (If value is null, condition is omitted automatically).