DSL.select()
.from(AUTHOR)
.where(AUTHOR.ID.eq(3));
Tools.title("A couple of settings at work - Formatting");
out.println(using(H2, new Settings().withRenderFormatted(false)).render(select));
out.println(using(H2, new Settings().withRenderFormatted(true)).render(select));
Tools.title("A couple of settings at work - Schema");
out.println(using(H2, new Settings().withRenderSchema(false)).render(select));
out.println(using(H2, new Settings().withRenderSchema(true)).render(select));
Tools.title("A couple of settings at work - Name style");
out.println(using(H2, new Settings().withRenderNameStyle(RenderNameStyle.AS_IS)).render(select));
out.println(using(H2, new Settings().withRenderNameStyle(RenderNameStyle.UPPER)).render(select));
out.println(using(H2, new Settings().withRenderNameStyle(RenderNameStyle.LOWER)).render(select));
out.println(using(H2, new Settings().withRenderNameStyle(RenderNameStyle.QUOTED)).render(select));
Tools.title("A couple of settings at work - Keyword style");
out.println(using(H2, new Settings().withRenderKeywordStyle(RenderKeywordStyle.UPPER)).render(select));
out.println(using(H2, new Settings().withRenderKeywordStyle(RenderKeywordStyle.LOWER)).render(select));
Tools.title("A couple of settings at work - Mapping");
out.println(using(H2, new Settings()
.withRenderMapping(new RenderMapping()
.withSchemata(new MappedSchema()
.withInput("PUBLIC")
.withOutput("test")
.withTables(new MappedTable()