Learn how to format your SQL objects and identifiers in a clear, consistent, and compliant way by following some best practices for naming, casing, quoting, and aliasing your SQL elements.

Here, we'll discuss a version of the latter ("modern") approach, derived from Mozilla's SQL Style Guide. The key difference from Mozilla's guide is that here we use lowercase SQL. The reason behind it ...

We know how to format SQL code in a .sql file, but what if we mix SQL into our Ruby code? The answer is to use a heredoc to write multi-line strings with ease: A heredoc produces a string just like ...

Arthur Fuller responds to a reader who sent him a question recently asking how to display currency amounts in currency format. Check out the solution he offers for the reader's problem.

Prophecy today launched a new version of its core platform to provide enterprises with low-code SQL capabilities for building data pipelines.