A SQL statement reformatter

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

A SQL statement reformatter

Simon Slavin-3
For those times when you have to understand a poorly-formatted SQL statement:

<https://sqlfum.pt>

I seem to prefer 'full' mode.

Simon.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: A SQL statement reformatter

Don V Nielsen
Slick. That line width slider feature is something we don't get using Poor
Man's Sql Formatter.

Thanks!

On Thu, Sep 27, 2018 at 7:03 PM Simon Slavin <[hidden email]> wrote:

> For those times when you have to understand a poorly-formatted SQL
> statement:
>
> <https://sqlfum.pt>
>
> I seem to prefer 'full' mode.
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: A SQL statement reformatter

Peter da Silva-2
Pity they aren't making the code available. Not sure I want to send company
SQL to a random site.

On Fri, Sep 28, 2018 at 7:48 AM Don V Nielsen <[hidden email]> wrote:

> Slick. That line width slider feature is something we don't get using Poor
> Man's Sql Formatter.
>
> Thanks!
>
> On Thu, Sep 27, 2018 at 7:03 PM Simon Slavin <[hidden email]> wrote:
>
> > For those times when you have to understand a poorly-formatted SQL
> > statement:
> >
> > <https://sqlfum.pt>
> >
> > I seem to prefer 'full' mode.
> >
> > Simon.
> > _______________________________________________
> > sqlite-users mailing list
> > [hidden email]
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: A SQL statement reformatter

Chris Brody
I found https://github.com/mjibson/sqlfmt through their about page. No
license though, just raised
https://github.com/mjibson/sqlfmt/issues/33.

GitHub fork-me ribbon would also be nice I think.

Someone should have make this tool 20-30 years ago!
On Fri, Sep 28, 2018 at 10:44 AM Peter da Silva <[hidden email]> wrote:

>
> Pity they aren't making the code available. Not sure I want to send company
> SQL to a random site.
>
> On Fri, Sep 28, 2018 at 7:48 AM Don V Nielsen <[hidden email]> wrote:
>
> > Slick. That line width slider feature is something we don't get using Poor
> > Man's Sql Formatter.
> >
> > Thanks!
> >
> > On Thu, Sep 27, 2018 at 7:03 PM Simon Slavin <[hidden email]> wrote:
> >
> > > For those times when you have to understand a poorly-formatted SQL
> > > statement:
> > >
> > > <https://sqlfum.pt>
> > >
> > > I seem to prefer 'full' mode.
> > >
> > > Simon.
> > > _______________________________________________
> > > sqlite-users mailing list
> > > [hidden email]
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > _______________________________________________
> > sqlite-users mailing list
> > [hidden email]
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: A SQL statement reformatter

Peter da Silva-2
Oh, nice!

On Fri, Sep 28, 2018 at 9:50 AM Chris Brody <[hidden email]> wrote:

> I found https://github.com/mjibson/sqlfmt through their about page. No
> license though, just raised
> https://github.com/mjibson/sqlfmt/issues/33.
>
> GitHub fork-me ribbon would also be nice I think.
>
> Someone should have make this tool 20-30 years ago!
> On Fri, Sep 28, 2018 at 10:44 AM Peter da Silva <[hidden email]> wrote:
> >
> > Pity they aren't making the code available. Not sure I want to send
> company
> > SQL to a random site.
> >
> > On Fri, Sep 28, 2018 at 7:48 AM Don V Nielsen <[hidden email]>
> wrote:
> >
> > > Slick. That line width slider feature is something we don't get using
> Poor
> > > Man's Sql Formatter.
> > >
> > > Thanks!
> > >
> > > On Thu, Sep 27, 2018 at 7:03 PM Simon Slavin <[hidden email]>
> wrote:
> > >
> > > > For those times when you have to understand a poorly-formatted SQL
> > > > statement:
> > > >
> > > > <https://sqlfum.pt>
> > > >
> > > > I seem to prefer 'full' mode.
> > > >
> > > > Simon.
> > > > _______________________________________________
> > > > sqlite-users mailing list
> > > > [hidden email]
> > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > > >
> > > _______________________________________________
> > > sqlite-users mailing list
> > > [hidden email]
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > _______________________________________________
> > sqlite-users mailing list
> > [hidden email]
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: A SQL statement reformatter

Simon Slavin-3
In reply to this post by Chris Brody
On 28 Sep 2018, at 3:49pm, Chris Brody <[hidden email]> wrote:

> Someone should have make this tool 20-30 years ago!

They did.  There have been others available, I just posted a new one.

<https://www.freeformatter.com/sql-formatter.html>

<http://www.dpriver.com/pp/sqlformat.htm>

<https://sqlformat.org>

The last one has its essential parts (written in Python) in github.

Simon.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users