Module SQL: Difference between revisions

Revision as of 13:17, 2 November 2023

Latest revision as of 02:03, 20 April 2025

(3 intermediate revisions by 3 users not shown)

Line 1:

{{Short description|Computer programming method}}

{{AfC topic|stem}}

{{AfC submission|||ts=20231102052147|u=Helena|ns=118}}

{{AFC submission|d|nn|u=Fjerdingen|ns=118|decliner=Tutwakhamoe|declinets=20231101022429|ts=20230607143145}} <!-- Do not remove this line! -->

{{AFC submission|d|nn|u=Helena|ns=118|decliner=Stuartyeates|declinets=20230510192146|small=yes|ts=20230330114355}} <!-- Do not remove this line! -->

'''Module SQL''' is a method of combining the [[computing]] power of a [[programming language]] and the [[database]] [[Data Manipulation Language|manipulation]] capabilities of [[SQL]]. Module SQL [[statement (programming)|statements]] are SQL statements written in an SQL client module, that can be called as routines from the host language program [[source code]] like a host language routine. An SQL standard Module Language file is [[compiler|compiled]] into calls to a SQL [[runtime library]] that interacts with the [[DBMS|Database management system]]. This allows programmers to call SQL statements from applications written in regular programming languages.

{{AFC comment|1=This reads like a description page for some item in Github. Consider adding sources that aren't just tutorials to show the subject's importance. If the advantage of the subject is to be demonstrated, it should be backed up with critic or comment from experts or notable organizations in this field. [[User:Tutwakhamoe|Tutwakhamoe]] ([[User talk:Tutwakhamoe|talk]]) 02:24, 1 November 2023 (UTC)}}

{{AFC comment|1=In-depth coverage in independent secondary sources are required. [[User:Stuartyeates|Stuartyeates]] ([[User talk:Stuartyeates|talk]]) 19:21, 10 May 2023 (UTC)}}

----

{{Draft topics|software|computing|technology}}

'''Module SQL''' is a method of combining the [[computing]] power of a [[programming language]] and the [[database]] [[Data Manipulation Language|manipulation]] capabilities of [[SQL]]. Module SQL [[statement (programming)|statements]] are SQL statements written in an SQL client module, that can be called as routines from the host language program [[source code]] like a host language routine. An SQL standard Module Language file is [[compiler|compiled]] into calls to a SQL runtime library that interacts with the [[DBMS|Database management system]]. This allows programmers to call SQL statements from applications written in regular programming languages.

Using Module Language is very straightforward: place all SQL code in a separate module, and define an interface between the module containing the SQL code and the host program.<ref name="modulelang">

Line 26 ⟶ 13:

Module SQL is closely related to [[Embedded SQL]]. "SQL client modules are self-contained collections of SQL statements. Unlike embedded SQL, in which the SQL statements are inserted into the host programming language, SQL client modules are separate from the host language. The host language contains calls that invoke the module, which in turn executes the SQL statements within that module."<ref>{{cite book |last1=Oppel |first1=Andrew |title=SQL: A Beginner's Guide, Fourth Edition, 4th Edition |date=November 2015 |publisher=McGraw-Hill |isbn=978-0071842594 |pages=544 |edition=4th |url=https://learning.oreilly.com/library/view/sql-a-beginners/9780071842570/ch18.html#:-:text=Create%20SQL%20Client%20Modules}}</ref>

=== SQL Standard Compliance= ==

The [[SQL:2023]] standard (ISO/IEC 9075-2:2023 Information technology — Database languages SQL — Part 2: Foundation (SQL/Foundation), chapter 13<ref>{{cite web

Line 57 ⟶ 44:

|url=https://docs.oracle.com/cd/A87860_01/doc/appdev.817/a58231.pdf

|title=SQL*Module™ for Ada - Programmer's Guide

|work=SQL*Module™ for Ada - Programmer's Guide

|publisher=Oracle Corporation

|accessdate=2023-06-19

Line 83 ⟶ 69:

* [https://developer.mimer.com/article/module-sql/ Module SQL, Mimer SQL Developer]

[[:Category:SQL]]

[[:Category:Declarative programming languages]]

[[:Category:Query languages]]

[[:Category:Data modeling languages]]

[[:Category:Database APIs]]

[[:Category:SQL data access]]