nilportugues / php-sql-query-builder

An elegant lightweight and efficient SQL Query Builder with fluid interface SQL syntax supporting bindings and complicated query generation.
http://nilportugues.com
MIT License
418 stars 115 forks source link

Export values #83

Open Dokans opened 7 years ago

Dokans commented 7 years ago

Hi, sorry it's not a real issue but it's somehow possible to export solo raw SQL for update or insert?

jcmosaiclearning commented 6 years ago

I too would like to do this. So far, I haven't seen anything obvious in the documentation.

marcus-hiles commented 5 years ago

@Dokans

$builder = new MySqlBuilder();
$query = $builder->select($table);
...
$sql = $builder->write($query); //gives the raw sql query