sql_tools 0.8.1

A rust crate meant to make SQL queries simple and communication between various SQL versions easy.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58

# Changelog


All notable changes to this project will be documented in this file.
Dates are labeled YYYY-MM-DD.

## [0.8.1] - 2025-11-12

### Added

- Impl ToSqlData trait for `Option<SQLDataType>` and `Box<Option<SQLDataType>>` 

## [0.8.0] - 2025-11-04

### Added

- WhereArgs enum

### Removed

- where_like, where_null, where_not_like, where_not_null, and_like, and_null, and_not_like, and_not_null, or_like, or_null, or_not_like, or_not_null

### Changed

- where_clause module to query_conjunctions
- WhereClauseBuilder to QueryConjunctions
- where_in, where_not, and, and_not, or, or_not all take a WhereArgs argument instead of Vec<T> where T: ToSQLData
- where_in and where_not no longer have their own individual traits for each statement type, instead they live in the QueryConjunctions trait

## [0.7.2] - 2025-10-27

### Improved

- Improved speed and memory usage for multithreaded select 

## [0.7.1] - 2025-10-23

### Fixed

- table_info method for SQLite was broken as a result of the table.column update in 0.7.0, fixed this to allow the function to work as intended

## [0.7.0] - 2025-10-20

### Added

- Added the ability to return header names via return_header() in select()
- More documentation for delete, select, create, and where clause methods

### Changed

- SQLVariations is now SQLImplementations to follow common naming conventions
- .create().add_column() now borrows self
- replaced fmt_data() with fmt_data_borrowed()'s functionality to avoid self consumption in method and rm fmt_data_borrowed()
- format_grid_strings() uses self instead of creating new struct
- made oracle col headers public
- Removed the `Table` struct and reverted all method params with this data type back to `&str`

## [0.6.0] - 2025-08-13

### Added

- Where "like" and "not like" statements
- Changed the input to the `update` method to a `Table` struct

## [0.5.1] - 2025-08-04

- Restructured where the sql variations are executing their statements (for easier maintenance and upgradeability)

## [0.5.0] - 2025-07-23

### Added

- Renamed the 'Clauses' module to the more appropriately named 'Statements'
- Added joins to the select statement

### Fixed

- Fixed single threaded builds not recognizing "*"