SQL formatting and syntax highlighting, for debugging.

If you want syntax highlighing, install the python package pygments: http://pygments.org/docs/cmdline/ and ensure that it's in your PATH.

This was not intended for anything other than debugging. It is likely INSECURE to use this for any other purpose.

In this example we're monkeypaching String to add a to_prety_sql method.

require 'pretty_sql'

class String

  include PrettySql

  def to_pretty_sql
    prettify_sql(self.dup)
  end
end

puts 'SELECT * FROM poop'.to_pretty_sql