Search Results for "pl/sql"

This library is a general-purpose SQL generator. Think of it as a typesafe and expressive SQL DSL (domain-specific language), with support for rendering SQL formatted properly for MyBatis3 and Spring's NamedParameterJDBCTemplate. The library also contains extensions for Kotlin that enable an idiomatic Kotlin DSL for SQL. The library will generate full DELETE, INSERT, SELECT, and UPDATE statements.

This is a Kotlin implementation of the PartiQL specification. PartiQL is based on SQL-92 and has added support for working with schemaless hierarchical data. PartiQL’s extensions to SQL are easy to understand, treat nested data as first-class citizens, and compose seamlessly with each other and SQL. This repository contains an embeddable reference interpreter, test framework, and tests for PartiQL in Kotlin.

Data frame is an abstraction for working with structured data. Essentially it’s a 2-dimensional table with labeled columns of potentially different types. You can think of it like a spreadsheet or SQL table, or a dictionary of series objects. The handiness of this abstraction is not in the table itself but in a set of operations defined on it. The Kotlin Dataframe library is an idiomatic Kotlin DSL defining such operations. The process of working with data frame is often called data wrangling which is the process of transforming and mapping data from one "raw" data form into another format that is more appropriate for analytics and visualization. ...

...Preview tables, views, and triggers. Preview table or view pragma. Preview table or view pragma. Search table, view or trigger. Sort table, view or trigger per column. Execute any valid SQL command in editor per database connection. If you use DbInspector for a specific flavor and need to override merged in launcher label, you can provide a String resource in your project. DbInspector has a build in editor scoped per database connection currently used.