We have some runnable SQL examples with assertion under the sequelize/raw directory.

These examples are written in the Sequelize library using raw queries.

Sequelize is used minimally, just to feed raw queries in transparently to any underlying database, and get minimally parsed results out for us, which we then assert with standard JavaScript. The queries themselves are all written by hand.

By default the examples run on SQLite. Just like the examples from sequelize example, you can set the database at runtime as:

Here we list only examples which we believe are standard SQL, and should therefore work across different SQL implementations:

Bond softening refers to a phenomenon observed in the context of materials science and solid-state physics, particularly in the study of mechanical properties of materials. It denotes a reduction in the strength of atomic or molecular bonds in a material, which can lead to a decrease in its overall mechanical strength and stiffness.

In chemistry, the term "field effect" often refers to the influence that an applied electric field can have on the properties and behavior of molecules, especially in the context of conductive materials and charge carrier mobility. While the term is more commonly associated with electronics (e.g., field-effect transistors), it does have applications in chemistry, particularly in areas like electrochemistry and molecular interactions.

A **rigid rotor** is a model used in molecular dynamics and quantum mechanics to describe the behavior of a rotating molecule where it is assumed that the bond lengths and angles between atoms do not change during rotation. This simplification means that the molecular structure is considered to be fixed and rigid, which allows for the analysis of the rotational motion of the entire molecule as a solid object.

The Chayanda field is an oil and gas field located in the Sakha (Yakutia) region of Russia. It is part of the East Siberian region, which has been the focus of significant exploration and development due to its rich hydrocarbon resources. The Chayanda field is particularly notable for being part of Russia's efforts to increase its production and export of natural gas, especially to Asia.

The National Helium Reserve, also known as the Federal Helium Reserve, is a government-owned facility located near Amarillo, Texas. It was established in the 1920s to ensure a stable supply of helium for various applications, including military and scientific uses, particularly during World War II and the Cold War.

The 1961 New South Wales earthquake occurred on December 28, 1961, and is one of the most significant seismic events in Australia's history. With a magnitude of 5.6, it struck near the town of Bargo, located southwest of Sydney. The earthquake was felt widely throughout the Sydney metropolitan area and as far away as Canberra and Goulburn.

A VM reactor, or a Virtual Machine reactor, typically refers to a component or architecture used in virtualization environments that manage and operate virtual machines (VMs). However, that specific term isn’t widely recognized in standard technical literature or industry usage. In general, virtualization technology allows multiple virtual machines to run on a single physical machine, each acting as an independent system with its own operating system and applications. This enables better resource utilization and flexibility in deploying and managing computing resources.

COVRA (Central Organisation for Radioactive Waste) is the Dutch facility responsible for the management and disposal of high-level radioactive waste generated in the Netherlands. Located in the municipality of Borsele, COVRA was established to provide a centralized solution for handling various types of radioactive waste, including spent nuclear fuel and other materials from nuclear power plants, medical facilities, and research institutions. COVRA's primary functions include the safe storage, treatment, and eventual disposal of radioactive waste.

The Kharkiv Nuclear Power Plant, also known as the Kharkiv NPP, is a proposed nuclear power facility in Ukraine. It has been a topic of discussion and planning for several years, reflecting Ukraine's interest in expanding its nuclear energy capabilities to meet growing energy demands, ensure energy security, and reduce reliance on fossil fuels.

"Pre-Konvoi" typically refers to an event, initiative, or program associated with the logistics or preparations that occur prior to a larger convoy operation, especially in contexts related to military or humanitarian efforts. The term may be tied to the organization and coordination required to ensure that all resources, personnel, and materials are ready for deployment.

AN 51 typically refers to "Advisory Notice 51," which is often issued by regulatory agencies or organizations in various fields, including aviation, finance, and engineering. These notices provide guidance, best practices, or updates on safety and regulatory issues. In aviation, for example, AN 51 might relate to safety regulations or operational procedures. The specific content and implications of AN 51 would depend on the context in which it is issued.

Ares was a series of American solid-fueled ballistic missiles developed in the 1960s. Specifically, it was intended to provide a rapid response to potential threats during the Cold War. The Ares program aimed to create a missile platform that could deliver nuclear warheads to strategic targets. The project was part of a broader U.S. defense strategy that included various missile systems, and it was developed during a time of escalating tensions and the arms race with the Soviet Union.

The term "Basic Encyclopedia" typically refers to a type of encyclopedia designed to provide straightforward, accessible information on a wide range of topics. These encyclopedias are often aimed at students, children, or individuals seeking a foundational understanding of various subjects without the complexity that might be found in more detailed reference works. Basic encyclopedias usually feature entries that are concise, easy to understand, and sometimes include illustrations or diagrams to aid comprehension.

"Britain, Australia and the Bomb" refers to the historical and political relationships focused on nuclear weapons and nuclear policy in the context of the British and Australian governments, particularly during the Cold War and post-World War II periods. The term often relates to discussions about the sharing of nuclear technology and intelligence, Australia's participation in the British nuclear tests, and the broader implications of nuclear strategy in the Asia-Pacific region.

The M1 missile generally refers to the M1 rocket, which can be associated with multiple systems depending on the context, as there are various missiles and systems that may share similar nomenclature. One notable reference is to the M1 missile or weapon system that was part of the advancements during the Cold War era or the development of missile technology by various nations.

Nuclear fratricide refers to the unintended damage or destruction caused by the detonation of nuclear weapons—specifically, when nuclear strikes affect one's own forces or assets, rather than the intended enemy targets. This notion can encompass various scenarios, such as a weapon impacting friendly troops or installations, or the fallout and radiation from a nuclear explosion harming one's own personnel or resources. The concept highlights the risks and complexities associated with nuclear warfare and deterrence strategies.

RDS-3, also known as "RDS-3A," was a nuclear bomb developed by the Soviet Union during the Cold War. It was part of the RDS series of nuclear weapons and was first tested in the early 1950s. The RDS-3 was essentially an early thermonuclear device, and it represented a significant step in the development of Soviet nuclear capabilities. The bomb was notable for its relatively compact design and was used primarily for testing purposes.

"The Psychology of Nuclear Proliferation" is a concept that explores the psychological factors influencing states' motivations to acquire nuclear weapons, as well as the implications of nuclear proliferation on international relations and security. While there isn't a definitive book or single theory that encapsulates this title, it broadly examines the interplay between human behavior, national identity, security perceptions, and strategic calculations in the context of nuclear armament.