1<?php 2 3namespace ipl\Sql; 4 5/** 6 * The SQL helper provides a set of static methods for quoting and escaping identifiers to make their use safe in SQL 7 * queries or fragments 8 */ 9class Sql 10{ 11 /** 12 * SQL AND operator 13 */ 14 const ALL = 'AND'; 15 16 /** 17 * SQL OR operator 18 */ 19 const ANY = 'OR'; 20 21 /** 22 * SQL AND NOT operator 23 */ 24 const NOT_ALL = 'AND NOT'; 25 26 /** 27 * SQL OR NOT operator 28 */ 29 const NOT_ANY = 'OR NOT'; 30 31 /** 32 * Create and return a DELETE statement 33 * 34 * @return Delete 35 */ 36 public static function delete() 37 { 38 return new Delete(); 39 } 40 41 /** 42 * Create and return a INSERT statement 43 * 44 * @return Insert 45 */ 46 public static function insert() 47 { 48 return new Insert(); 49 } 50 51 /** 52 * Create and return a SELECT statement 53 * 54 * @return Select 55 */ 56 public static function select() 57 { 58 return new Select(); 59 } 60 61 /** 62 * Create and return a UPDATE statement 63 * 64 * @return Update 65 */ 66 public static function update() 67 { 68 return new Update(); 69 } 70} 71