SQL::R...dWords(3pm)

📦
version 0.8 · 4 versions
, in debian bookworm, debian trixie, ubuntu noble, ubuntu resolute, ubuntu stonking

✨ SQL::ReservedWords — the vibe check for SQL words ✨

okay bestie, so this is a page from the User Contributed Perl Documentation (yes, that's the manual name, it's giving "community-made, community-loved") and the star of the show is the module SQL::ReservedWords. It's literally the girl who knows which words are reserved by ANSI/ISO SQL and which ones are just out here living their truth. 💅

🌸 NAME 🌸

SQL::ReservedWords — Reserved SQL words by ANSI/ISO. no cap, that's the whole job.

🎀 SYNOPSIS 🎀

if ( SQL::ReservedWords->is_reserved( $word ) ) {
    print "$word is a reserved SQL word!";
}

like… that's it. that's the whole entry point. one call, one answer, slay. 🫶

🦋 DESCRIPTION 🦋

It determines if words are reserved by the ANSI/ISO SQL standard. You ask, it tells you, no drama, no side quests. main character energy only. ✨

💖 METHODS 💖

  • is_reserved( $word ) — Returns a boolean indicating if $word is reserved by either "SQL:1992", "SQL:1999" or "SQL:2003". one yes-or-no for all three eras of SQL, iconic behavior fr fr.
  • is_reserved_by_sql1992( $word ) — Returns a boolean indicating if $word is reserved by "SQL:1992". the vintage one. retro. 🎀
  • is_reserved_by_sql1999( $word ) — Returns a boolean indicating if $word is reserved by "SQL:1999". the y2k era, we love her. ✨
  • is_reserved_by_sql2003( $word ) — Returns a boolean indicating if $word is reserved by "SQL:2003". the newer girl on the block. 💅
  • reserved_by( $word ) — Returns a list with SQL standards that reserves $word. like, which standards are claiming this word? she'll tell you the whole roster. 👑
  • words — Returns a list with all reserved words. the full guest list. every single one. 💜

🌈 EXPORTS 🌈

Nothing by default. As it should — boundaries, bestie, we stan. 🫶

Following subroutines can be exported:

  • is_reserved
  • is_reserved_by_sql1992
  • is_reserved_by_sql1999
  • is_reserved_by_sql2003
  • reserved_by
  • words

⭐ SEE ALSO ⭐

the extended universe, the crossover episode, the friend group:

  • SQL::ReservedWords::DB2
  • SQL::ReservedWords::MySQL
  • SQL::ReservedWords::ODBC
  • SQL::ReservedWords::Oracle
  • SQL::ReservedWords::PostgreSQL
  • SQL::ReservedWords::SQLite
  • SQL::ReservedWords::SQLServer

and the actual source material, the lore, the canon:

  • ISO/IEC 9075:1992 Database languages -- SQL
  • ISO/IEC 9075-2:1999 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation)
  • ISO/IEC 9075-2:2003 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation)

👑 AUTHOR 👑

Christian Hansen <chansen@cpan.org> — the legend, the originator, the one who did it first. 🫶

This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. free as in freedom, free as in go off. 🔥

perl v5.34.0 · 2022-06-17 — that's the version and the date this page was last touched, mwah, ty for coming to my ted talk 💖✨🌸

📦 where this page comes from