Change Log

Version 3.4.1 #

  1. Fixed: SQL Server syntax for fetch rows

Version 3.4.0 #

  1. Added: new line before keyword sql output mode

Version 3.3.0 #

  1. Added: Ability to return new query of anynomous alias function in from() method

Version 3.2.0 #

  1. Added: Ability to query from table alias

Version 3.1.0 #

  1. Fixed: Small bug in generating delete query

Version 3.0.0 #

  1. Add whereOpenBracket(), whereCloseBracket() methods
  2. Add option to build named and question mark parameter query and its parameter values to improve security
  3. Add schemas to Query to check select validity
  4. Add ability to call procedure with parameters
  5. Add procedure call
  6. Add Oracle syntax support

Version 2.5.3 #

  1. Fix the toArray() method
  2. Fix issue with where() method

Version 2.5.1 #

  1. Fix Query's rebuildSubQueries() method and make its toArray() recursive.

Version 2.5.0 #

  1. Enhance the selectRaw(), whereRaw() and orderByRaw()

Version 2.0.0 #

  1. Query: Fix the selectRaw rendering
  2. Query: Adding parameters to whereRaw(), havingRaw(), orderByRaw() methods
  3. SQL: Add options to set quotes for identifiers
  4. SQL: Make default not use quotes for identifiers
  5. SQLServer: Generate correct query for limit and offset
  6. Query: Add groupByRaw() method
  7. Query: Add create() static function to create query from array
  8. Query: Adding toArray() function to export query to array format
  9. Query: Add fill() method to quickly fill query with array
  10. Query: Fix the whereRaw binding params

Version 1.5.0 #

  1. Change README

Version 1.4.0 #

  1. Fix aggregate

Version 1.3.0 #

  1. Fix error of where condition when value is boolean type
  2. Fix the cover identifier for [table.column] format

Version 1.2.0 #

  1. Change function "as" to "alias",
  2. Change function "switch" to "branch"
  3. Render query correctly for update and insert when encounter boolean value
  4. Fix the PostgresQL interpreter

Version 1.1.0 #

  1. When value of where condition is null, change from "=" to is null

Version 1.0.0 #

Get started with KoolReport

KoolReport will help you to construct good php data report by gathering your data from multiple sources, transforming them into valuable insights, and finally visualizing them in stunning charts and graphs.