| ParensExtern | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Types.Core, Napkin.Untyped |
| ParensOperator | |
| 1 (Type/Class) | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Types.Core, Napkin.Untyped |
| 2 (Data Constructor) | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Types.Core, Napkin.Untyped |
| ParensOperatorArgument | |
| 1 (Type/Class) | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Types.Core, Napkin.Untyped |
| 2 (Data Constructor) | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Types.Core, Napkin.Untyped |
| ParensOperatorConst | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Types.Core, Napkin.Untyped |
| parse | Napkin.Backends.MsSql |
| parseBigQueryURI | Napkin.Backends.BigQuery |
| parseDate | Napkin.Backends.BigQuery |
| parseDateTime | Napkin.Backends.BigQuery |
| parseExtendedStatement | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| parseJSON | Napkin.Spec.Prelude |
| parseJson | Napkin.Backends.BigQuery |
| parseName | Napkin.Backends.MsSql |
| parserlessHook | Napkin.Run.Effects, Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Spec.Types |
| parserlessPreprocessor | Napkin.Run.Effects, Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Spec.Types |
| parserlessSpec | Napkin.Run.Effects, Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Spec.Types |
| parseSqlExp | Napkin.Run.Effects, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| ParseSqlExp' | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| parseSqlExp' | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| parseSqlQuery | Napkin.Run.Effects, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| ParseSqlQuery' | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| parseSqlQuery' | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| ParseSqlStatements' | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| parseSqlStatements' | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| parseStatements | Napkin.Run.Effects, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| ParseTime | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| parseTimeM | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| parseTimeMultipleM | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| parseTimeOrError | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| parseTimestamp | Napkin.Backends.BigQuery |
| parse_USING | Napkin.Backends.MsSql |
| Partition | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Types.Core, Napkin.Untyped |
| partitionEithers | Napkin.Spec.Prelude |
| partitioning | |
| 1 (Function) | Napkin.Backends.BigQuery |
| 2 (Function) | Napkin.Backends.BigQuery |
| PartitionInterval | Napkin.Backends.BigQuery |
| PartitionInterval_Day | Napkin.Backends.BigQuery |
| PartitionInterval_Hour | Napkin.Backends.BigQuery |
| PartitionInterval_Month | Napkin.Backends.BigQuery |
| PartitionInterval_Year | Napkin.Backends.BigQuery |
| partitionWith | Napkin.Spec.Prelude |
| pass | Napkin.Spec.Prelude |
| pastMidnight | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| path | Napkin.Cli.Types |
| payloadKeys | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| payloadObject | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| PayloadSelection | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| percentDiff | |
| 1 (Function) | Napkin.Backends.BigQuery |
| 2 (Function) | Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| percentileAgg | Napkin.Backends.Timescale |
| percentileApproxPercentile | Napkin.Backends.Timescale |
| percentileApproxPercentileRank | Napkin.Backends.Timescale |
| percentileColumns | |
| 1 (Function) | Napkin.Backends.BigQuery |
| 2 (Function) | Napkin.Untyped.Utils.Redshift, Napkin.Untyped.Utils.Postgres, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| percentileCont | |
| 1 (Function) | Napkin.Backends.BigQuery |
| 2 (Function) | Napkin.Backends.MsSql |
| 3 (Function) | Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| percentileDisc | |
| 1 (Function) | Napkin.Backends.BigQuery |
| 2 (Function) | Napkin.Backends.MsSql |
| 3 (Function) | Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| percentileError | Napkin.Backends.Timescale |
| percentileMaxVal | Napkin.Backends.Timescale |
| percentileMean | Napkin.Backends.Timescale |
| percentileMinVal | Napkin.Backends.Timescale |
| percentileNumVals | Napkin.Backends.Timescale |
| percentileRollup | Napkin.Backends.Timescale |
| percentileTdigest | Napkin.Backends.Timescale |
| percentileUddsketch | Napkin.Backends.Timescale |
| percentRank | |
| 1 (Function) | Napkin.Backends.BigQuery |
| 2 (Function) | Napkin.Backends.MsSql |
| 3 (Function) | Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| percent_rank | Napkin.Backends.Sqlite |
| periodAllDays | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| periodFirstDay | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| periodFromDay | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| periodLastDay | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| periodLength | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| periodToDay | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| periodToDayValid | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| permissions | Napkin.Backends.MsSql |
| permissions_Objectid | Napkin.Backends.MsSql |
| permissions_Objectid_Column | Napkin.Backends.MsSql |
| permitAND | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| PermitFunc | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| permitItem | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| permitOR | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| permutations | Napkin.Spec.Prelude |
| pgSQL | Napkin.Parse.TH, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| pgSQLFrom | Napkin.Parse.TH, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| pgSQLRel | Napkin.Parse.TH, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| pgSQLSelExps | Napkin.Parse.TH, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| pgSQLSExp | Napkin.Parse.TH, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| phantom | Napkin.Spec.Prelude |
| pi | |
| 1 (Function) | Napkin.Spec.Prelude |
| 2 (Function) | Napkin.Backends.MsSql |
| 3 (Function) | Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| picosecondsToDiffTime | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| pIdT | Napkin.Backends.BigQuery |
| pollJob | Napkin.Backends.BigQuery |
| polyfill | Napkin.Untyped.Ops.Sqlite.Polyfill |
| polyfillData | Napkin.Untyped.Ops.Sqlite.Polyfill |
| polyfillSExp | Napkin.Untyped.Ops.Sqlite.Polyfill |
| position | Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| PositionalBoundsCteBody | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Types.Core, Napkin.Untyped |
| Postgres | Napkin.Backends.Postgres, Napkin.Backends.Timescale |
| PostgresAExpr | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Types.Core, Napkin.Untyped |
| PostgresConn | Napkin.Backends.Postgres, Napkin.Backends.Timescale |
| PostgresExtra | Napkin.Backends.Postgres, Napkin.Backends.Timescale |
| PostgreSQL | Napkin.Run.Effects, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| PostgresSchemaField | Napkin.Backends.Postgres, Napkin.Backends.Timescale |
| PostgresSelectStmt | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Types.Core, Napkin.Untyped |
| postHooks | Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Spec.Types |
| pow | Napkin.Backends.BigQuery |
| power | |
| 1 (Function) | Napkin.Backends.BigQuery |
| 2 (Function) | Napkin.Backends.MsSql |
| 3 (Function) | Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| pred | Napkin.Spec.Prelude, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| Predicate | |
| 1 (Type/Class) | Napkin.Spec.Prelude |
| 2 (Data Constructor) | Napkin.Spec.Prelude |
| PredicateSExp | Napkin.Run.Effects.Hooks.Types |
| Prefix | |
| 1 (Type/Class) | Napkin.Types.Commands |
| 2 (Data Constructor) | Napkin.Types.Commands |
| preHooks | Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Spec.Types |
| Prepend | Napkin.Cli.Types |
| prettyCallStack | Napkin.Spec.Prelude |
| prettyPrintAssertionEntry | Napkin.Run.Assertions, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| prettyPrintAssertionGroup | Napkin.Run.Assertions, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| prettyPrintNapkinEffectError | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| prettyPrintSqlParseError | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| prettySrcLoc | Napkin.Spec.Prelude |
| preview | Napkin.Spec.Prelude |
| print | Napkin.Spec.Prelude |
| printSql | Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| Prism' | Napkin.Spec.Prelude |
| prism' | Napkin.Spec.Prelude |
| Product | |
| 1 (Type/Class) | Napkin.Spec.Prelude |
| 2 (Data Constructor) | Napkin.Spec.Prelude |
| product | Napkin.Spec.Prelude |
| ProgramAndHooksDependenciesAndQueries | Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Spec.Types |
| ProgramDependenciesAndQueries | Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Spec.Types |
| programToSpec | Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift |
| projectId | Napkin.Backends.BigQuery |
| properFraction | Napkin.Spec.Prelude |
| ProtoErrors | Napkin.Backends.BigQuery |
| ProvidedExplicitly | Napkin.Backends.BigQuery |
| Proxy | |
| 1 (Type/Class) | Napkin.Spec.Prelude |
| 2 (Data Constructor) | Napkin.Spec.Prelude |
| publishingserverName | Napkin.Backends.MsSql |
| pure | Napkin.Spec.Prelude, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Untyped |
| PureGlobalHookProgram | Napkin.Run.Effects, Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Spec.Types |
| PureGlobalHookProgram' | Napkin.Run.Effects, Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Spec.Types |
| PureGlobalHookProgramEffects | Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Spec.Types |
| PureSpecGlobalHook | Napkin.Spec, Napkin.Backends.Sqlite, Napkin.Backends.MsSql, Napkin.Backends.BigQuery, Napkin.Backends.Postgres, Napkin.Backends.Timescale, Napkin.Backends.Redshift, Napkin.Spec.Types |
| putBS | Napkin.Spec.Prelude |
| putBSLn | Napkin.Spec.Prelude |
| putLBS | Napkin.Spec.Prelude |
| putLBSLn | Napkin.Spec.Prelude |
| putLText | Napkin.Spec.Prelude |
| putLTextLn | Napkin.Spec.Prelude |
| putMVar | Napkin.Spec.Prelude |
| putStr | Napkin.Spec.Prelude |
| putStrLn | Napkin.Spec.Prelude |
| putText | Napkin.Spec.Prelude |
| putTextLn | Napkin.Spec.Prelude |
| putTMVar | Napkin.Spec.Prelude |
| pwdCompare | Napkin.Backends.MsSql |
| pwdCompare_Version | Napkin.Backends.MsSql |
| pwdEncrypt | Napkin.Backends.MsSql |