dialect

README

dialect

The dialect package handles differences in SQL dialects.

There is no backward compatibility guarantee for this package.

Documentation

Overview

Package dialect handles differences in various SQL dialects.

Index

• type Dialect
  • func For(name string) Dialect

Types

type Dialect

type Dialect interface {
	// Name of the dialect.
	Name() string

	// Quote a table name or column name so that it does
	// not clash with any reserved words. The SQL-99 standard
	// specifies double quotes (eg "table_name"), but many
	// dialects, including MySQL use the backtick (eg `table_name`).
	// SQL server uses square brackets (eg [table_name]).
	Quote(name string) string

	// Return the placeholder for binding a variable value.
	// Most SQL dialects support a single question mark (?), but
	// PostgreSQL uses numbered placeholders (eg $1).
	Placeholder(n int) string
}

Dialect is an interface used to handle differences in SQL dialects.

func For

func For(name string) Dialect

For returns a dialect for the specified database driver. If name is blank, then the dialect returned is for the first driver returned by sql.Drivers(). If the driver name is unknown, the default dialect is returned.

Supported dialects include:

name      alternative names
----      -----------------
mssql
mysql
postgres  pq, postgresql
sqlite3   sqlite
ql        ql-mem