RenderSql String Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> String -> Doc #
RenderSql String Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> String -> Doc #
RenderSql String Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> String -> Doc #
RenderSql String BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> String -> Doc #
RenderSql Query Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> Query -> Doc #
RenderSql Query Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> Query -> Doc #
RenderSql Query Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Query -> Doc #
RenderSql Query BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> Query -> Doc #
RenderSql From Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> From -> Doc #
RenderSql From Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> From -> Doc #
RenderSql From Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> From -> Doc #
RenderSql From BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> From -> Doc #
RenderSql Relation Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> Relation -> Doc #
RenderSql Relation Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> Relation -> Doc #
RenderSql Relation Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Relation -> Doc #
RenderSql Relation BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> Relation -> Doc #
RenderSql SExp Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> SExp -> Doc #
RenderSql SExp Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> SExp -> Doc #
RenderSql SExp Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> SExp -> Doc #
RenderSql SExp BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> SExp -> Doc #
RenderSql Grant Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> Grant -> Doc #
RenderSql Grant Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Grant -> Doc #
RenderSql Actor Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> Actor -> Doc #
RenderSql Actor Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Actor -> Doc #
RenderSql Object Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> Object -> Doc #
RenderSql Object Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> Object -> Doc #
RenderSql Object Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Object -> Doc #
RenderSql Privilege Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> Privilege -> Doc #
RenderSql Privilege Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Privilege -> Doc #
RenderSql ML_Predict BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> ML_Predict -> Doc #
RenderSql CreateModel BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> CreateModel -> Doc #
RenderSql ModelOptions BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> ModelOptions -> Doc #
RenderSql ModelType BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> ModelType -> Doc #
RenderSql Replacement BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> Replacement -> Doc #
RenderSql DeleteFrom Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> DeleteFrom -> Doc #
RenderSql DeleteFrom Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> DeleteFrom -> Doc #
RenderSql DeleteFrom Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> DeleteFrom -> Doc #
RenderSql DeleteFrom BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> DeleteFrom -> Doc #
RenderSql InsertIntoQuery Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> InsertIntoQuery -> Doc #
RenderSql InsertIntoQuery Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> InsertIntoQuery -> Doc #
RenderSql InsertIntoQuery Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> InsertIntoQuery -> Doc #
RenderSql InsertIntoQuery BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> InsertIntoQuery -> Doc #
RenderSql DropTable Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> DropTable -> Doc #
RenderSql DropTable Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> DropTable -> Doc #
RenderSql DropTable Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> DropTable -> Doc #
RenderSql DropView Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> DropView -> Doc #
RenderSql DropView Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> DropView -> Doc #
RenderSql DropView Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> DropView -> Doc #
RenderSql CreateViewAs Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> CreateViewAs -> Doc #
RenderSql CreateViewAs Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> CreateViewAs -> Doc #
RenderSql CreateViewAs Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> CreateViewAs -> Doc #
RenderSql CreateViewAs BigQuery #	Debug the underlying query; BigQuery can't create views via SQL.
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> CreateViewAs -> Doc #
RenderSql RenameTable Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> RenameTable -> Doc #
RenderSql RenameTable Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> RenameTable -> Doc #
RenderSql RenameTable Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> RenameTable -> Doc #
RenderSql SortKey Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> SortKey -> Doc #
RenderSql SortStyle Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> SortStyle -> Doc #
RenderSql DistStyle Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> DistStyle -> Doc #
RenderSql (Alias SExp) backend => RenderSql [Alias SExp] backend #
Instance details Defined in Napkin.Render.Common Methods renderSql :: backend -> [Alias SExp] -> Doc #
RenderSql a backend => RenderSql (Maybe a) backend #
Instance details Defined in Napkin.Render.Types Methods renderSql :: backend -> Maybe a -> Doc #
RenderSql a Sqlite => RenderSql (Alias a) Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> Alias a -> Doc #
RenderSql a Redshift => RenderSql (Alias a) Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> Alias a -> Doc #
RenderSql a Postgres => RenderSql (Alias a) Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Alias a -> Doc #
RenderSql a BigQuery => RenderSql (Alias a) BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> Alias a -> Doc #
RenderSql Query backend => RenderSql (Q a) backend #	Monadic query interface
Instance details Defined in Napkin.Render.Types Methods renderSql :: backend -> Q a -> Doc #
RenderSql (CreateTableAs ()) Sqlite #	Commands
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> CreateTableAs () -> Doc #
RenderSql (CreateTableAs ()) Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> CreateTableAs () -> Doc #
RenderSql (CreateTableAs ()) Postgres #	Commands
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> CreateTableAs () -> Doc #
RenderSql (CreateTableAs ()) BigQuery #	Debug the underlying query; BigQuery can't create tables via SQL.
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> CreateTableAs () -> Doc #
RenderSql (CreateTableAs TableMeta) Redshift #	Commands
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> CreateTableAs TableMeta -> Doc #
RenderSql (CreateTableAs TableMeta) BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> CreateTableAs TableMeta -> Doc #
RenderSql (Ref t) Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods renderSql :: Sqlite -> Ref t -> Doc #
RenderSql (Ref t) Redshift #
Instance details Defined in Napkin.Render.Redshift Methods renderSql :: Redshift -> Ref t -> Doc #
RenderSql (Ref t) Postgres #
Instance details Defined in Napkin.Render.Postgres Methods renderSql :: Postgres -> Ref t -> Doc #
RenderSql (Ref t) BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods renderSql :: BigQuery -> Ref t -> Doc #

class CommandDescr a backend where #

Methods

commandDescr :: backend -> a -> String #

Instances

Instances details

CommandDescr Grant Redshift #
Instance details Defined in Napkin.Render.Redshift Methods commandDescr :: Redshift -> Grant -> String #
CommandDescr Grant Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> Grant -> String #
CommandDescr DeleteFrom Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods commandDescr :: Sqlite -> DeleteFrom -> String #
CommandDescr DeleteFrom Redshift #
Instance details Defined in Napkin.Render.Redshift Methods commandDescr :: Redshift -> DeleteFrom -> String #
CommandDescr DeleteFrom Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> DeleteFrom -> String #
CommandDescr DeleteFrom BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods commandDescr :: BigQuery -> DeleteFrom -> String #
CommandDescr InsertIntoQuery Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods commandDescr :: Sqlite -> InsertIntoQuery -> String #
CommandDescr InsertIntoQuery Redshift #
Instance details Defined in Napkin.Render.Redshift Methods commandDescr :: Redshift -> InsertIntoQuery -> String #
CommandDescr InsertIntoQuery Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> InsertIntoQuery -> String #
CommandDescr InsertIntoQuery BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods commandDescr :: BigQuery -> InsertIntoQuery -> String #
CommandDescr DropTable Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods commandDescr :: Sqlite -> DropTable -> String #
CommandDescr DropTable Redshift #
Instance details Defined in Napkin.Render.Redshift Methods commandDescr :: Redshift -> DropTable -> String #
CommandDescr DropTable Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> DropTable -> String #
CommandDescr DropTable BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods commandDescr :: BigQuery -> DropTable -> String #
CommandDescr DropView Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods commandDescr :: Sqlite -> DropView -> String #
CommandDescr DropView Redshift #
Instance details Defined in Napkin.Render.Redshift Methods commandDescr :: Redshift -> DropView -> String #
CommandDescr DropView Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> DropView -> String #
CommandDescr DropView BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods commandDescr :: BigQuery -> DropView -> String #
CommandDescr CreateViewAs Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods commandDescr :: Sqlite -> CreateViewAs -> String #
CommandDescr CreateViewAs Redshift #
Instance details Defined in Napkin.Render.Redshift Methods commandDescr :: Redshift -> CreateViewAs -> String #
CommandDescr CreateViewAs Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> CreateViewAs -> String #
CommandDescr CreateViewAs BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods commandDescr :: BigQuery -> CreateViewAs -> String #
CommandDescr RenameTable Sqlite #
Instance details Defined in Napkin.Render.Sqlite Methods commandDescr :: Sqlite -> RenameTable -> String #
CommandDescr RenameTable Redshift #
Instance details Defined in Napkin.Render.Redshift Methods commandDescr :: Redshift -> RenameTable -> String #
CommandDescr RenameTable Postgres #
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> RenameTable -> String #
CommandDescr (CreateTableAs ()) Sqlite #	Command descriptions
Instance details Defined in Napkin.Render.Sqlite Methods commandDescr :: Sqlite -> CreateTableAs () -> String #
CommandDescr (CreateTableAs ()) Redshift #
Instance details Defined in Napkin.Render.Redshift Methods commandDescr :: Redshift -> CreateTableAs () -> String #
CommandDescr (CreateTableAs ()) Postgres #	Command descriptions
Instance details Defined in Napkin.Render.Postgres Methods commandDescr :: Postgres -> CreateTableAs () -> String #
CommandDescr (CreateTableAs ()) BigQuery #
Instance details Defined in Napkin.Render.BigQuery Methods commandDescr :: BigQuery -> CreateTableAs () -> String #
CommandDescr (CreateTableAs TableMeta) Redshift #	Command descriptions
Instance details Defined in Napkin.Render.Redshift Methods commandDescr :: Redshift -> CreateTableAs TableMeta -> String #

data RenderedSql #

Constructors

forall a backend.RenderSql a backend => RenderedSql backend a

unpackRenderedSql :: RenderedSql -> String #

class ReplaceReference backend where #

Ability to hackishly replace references to a given table within a SQL string blob. Enables namespacing and we wouldn't need it if we could comprehensively parse each backend's SQL.

Minimal complete definition

Nothing

Methods

replaceReference #

Arguments

:: Proxy backend
-> Ref Table	Search for this table
-> Ref Table	Replace with this table
-> Text	I give you a whole SQL blob fixer
-> Text

Instances

Instances details

ReplaceReference Sqlite #	Reference replacement
Instance details Defined in Napkin.Render.Sqlite Methods replaceReference :: Proxy Sqlite -> Ref Table -> Ref Table -> Text -> Text #
ReplaceReference Redshift #	Reference replacement
Instance details Defined in Napkin.Render.Redshift Methods replaceReference :: Proxy Redshift -> Ref Table -> Ref Table -> Text -> Text #
ReplaceReference Postgres #	Reference replacement
Instance details Defined in Napkin.Render.Postgres Methods replaceReference :: Proxy Postgres -> Ref Table -> Ref Table -> Text -> Text #
ReplaceReference BigQuery #	Reference replacement
Instance details Defined in Napkin.Render.BigQuery Methods replaceReference :: Proxy BigQuery -> Ref Table -> Ref Table -> Text -> Text #

Key	Shortcut
s	Open this search box
esc	Close this search box
↓,ctrl + j	Move down in search results
↑,ctrl + k	Move up in search results
↵	Go to active search result