> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SqlParameters

> SqlParameters — Kinetica Rust API

[gpudb\_api](https://docs.kinetica.com/content/api/rust/index.md)::<wbr />[sql\_iterator](https://docs.kinetica.com/content/api/rust/sql_iterator/index.md)
[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L34-L49)&#x20;

<pre>`pub enum SqlParameters {    Text(String),    Values(Vec<String>),    Json(Value),}`</pre>

The query parameters of [`Kinetica::execute_with_parameters`](https://docs.kinetica.com/content/api/rust/gpudb/struct.Kinetica/execute-with-parameters#method.execute_with_parameters) and [`Kinetica::query_with_parameters`](https://docs.kinetica.com/content/api/rust/gpudb/struct.Kinetica/query-with-parameters#method.query_with_parameters), sent as the `query_parameters` SQL option.

## Variants

### Text([String](https://doc.rust-lang.org/1.98.1/alloc/string/struct.String.html))

Parameters given as text, sent as they are.

### Values([Vec](https://doc.rust-lang.org/1.98.1/alloc/vec/struct.Vec.html)\<[String](https://doc.rust-lang.org/1.98.1/alloc/string/struct.String.html)>)

Parameter values, sent as a JSON array.

### Json([Value](https://docs.rs/serde_json/1.0.149/serde_json/value/enum.Value.html))

Parameters of any JSON type – numbers, booleans, nulls, text, arrays and objects – sent as JSON text. So `[1, 2.5, null]` goes as `[1,2.5,null]`, typed, where [`Self::Values`](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters#variant.Values) would send text. Build it with `serde_json::json!`, or from a `Vec<serde_json::Value>`.The server decides what it takes. Kinetica 7.2.3.21 binds numbers, text and nulls with their types (`SELECT $1` of `[1, null]` is an int and a null), refuses a boolean (“Unexpected json value in query\_parameters”), and takes nested arrays only for an INSERT.

## Trait Implementations

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L33)
impl [Clone](https://doc.rust-lang.org/1.98.1/core/clone/trait.Clone.html) for [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L33)
fn [clone](https://doc.rust-lang.org/1.98.1/core/clone/trait.Clone.html#tymethod.clone)(\&self) -> [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)

Returns a duplicate of the value. [Read more](https://doc.rust-lang.org/1.98.1/core/clone/trait.Clone.html#tymethod.clone)

1.0.0 (const: [unstable](https://github.com/rust-lang/rust/issues/142757)) · [Source](https://doc.rust-lang.org/1.98.1/src/core/clone.rs.html#245-247)
fn [clone\_from](https://doc.rust-lang.org/1.98.1/core/clone/trait.Clone.html#method.clone_from)(\&mut self, source: \&Self)

Performs copy-assignment from `source`. [Read more](https://doc.rust-lang.org/1.98.1/core/clone/trait.Clone.html#method.clone_from)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L33)
impl [Debug](https://doc.rust-lang.org/1.98.1/core/fmt/trait.Debug.html) for [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L33)
fn [fmt](https://doc.rust-lang.org/1.98.1/core/fmt/trait.Debug.html#tymethod.fmt)(\&self, f: \&mut [Formatter](https://doc.rust-lang.org/1.98.1/core/fmt/struct.Formatter.html)\<'\_>) -> [Result](https://doc.rust-lang.org/1.98.1/core/fmt/type.Result.html)

Formats the value using the given formatter. [Read more](https://doc.rust-lang.org/1.98.1/core/fmt/trait.Debug.html#tymethod.fmt)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L33)
impl [Eq](https://doc.rust-lang.org/1.98.1/core/cmp/trait.Eq.html) for [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L69-L73)
impl [From](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html)\<&\[&[str](https://doc.rust-lang.org/1.98.1/std/primitive.str.html)]> for [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L70-L72)
fn [from](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html#tymethod.from)(values: &\[&[str](https://doc.rust-lang.org/1.98.1/std/primitive.str.html)]) -> Self

Converts to this type from the input type.

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L51-L55)
impl [From](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html)\<&[str](https://doc.rust-lang.org/1.98.1/std/primitive.str.html)> for [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L52-L54)
fn [from](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html#tymethod.from)(text: &[str](https://doc.rust-lang.org/1.98.1/std/primitive.str.html)) -> Self

Converts to this type from the input type.

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L57-L61)
impl [From](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html)\<[String](https://doc.rust-lang.org/1.98.1/alloc/string/struct.String.html)> for [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L58-L60)
fn [from](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html#tymethod.from)(text: [String](https://doc.rust-lang.org/1.98.1/alloc/string/struct.String.html)) -> Self

Converts to this type from the input type.

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L75-L79)
impl [From](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html)\<[Value](https://docs.rs/serde_json/1.0.149/serde_json/value/enum.Value.html)> for [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L76-L78)
fn [from](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html#tymethod.from)(value: [Value](https://docs.rs/serde_json/1.0.149/serde_json/value/enum.Value.html)) -> Self

Converts to this type from the input type.

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L63-L67)
impl [From](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html)\<[Vec](https://doc.rust-lang.org/1.98.1/alloc/vec/struct.Vec.html)\<[String](https://doc.rust-lang.org/1.98.1/alloc/string/struct.String.html)>> for [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L64-L66)
fn [from](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html#tymethod.from)(values: [Vec](https://doc.rust-lang.org/1.98.1/alloc/vec/struct.Vec.html)\<[String](https://doc.rust-lang.org/1.98.1/alloc/string/struct.String.html)>) -> Self

Converts to this type from the input type.

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L81-L85)
impl [From](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html)\<[Vec](https://doc.rust-lang.org/1.98.1/alloc/vec/struct.Vec.html)\<[Value](https://docs.rs/serde_json/1.0.149/serde_json/value/enum.Value.html)>> for [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L82-L84)
fn [from](https://doc.rust-lang.org/1.98.1/core/convert/trait.From.html#tymethod.from)(values: [Vec](https://doc.rust-lang.org/1.98.1/alloc/vec/struct.Vec.html)\<[Value](https://docs.rs/serde_json/1.0.149/serde_json/value/enum.Value.html)>) -> Self

Converts to this type from the input type.

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L33)
impl [PartialEq](https://doc.rust-lang.org/1.98.1/core/cmp/trait.PartialEq.html) for [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L33)
fn [eq](https://doc.rust-lang.org/1.98.1/core/cmp/trait.PartialEq.html#tymethod.eq)(\&self, other: &[SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)) -> [bool](https://doc.rust-lang.org/1.98.1/std/primitive.bool.html)

Tests for `self` and `other` values to be equal, and is used by `==`.

1.0.0 (const: [unstable](https://github.com/rust-lang/rust/issues/143800)) · [Source](https://doc.rust-lang.org/1.98.1/src/core/cmp.rs.html#263)
fn [ne](https://doc.rust-lang.org/1.98.1/core/cmp/trait.PartialEq.html#method.ne)(\&self, other: [\&Rhs](https://doc.rust-lang.org/1.98.1/std/primitive.reference.html)) -> [bool](https://doc.rust-lang.org/1.98.1/std/primitive.bool.html)

Tests for `!=`. The default implementation is almost always sufficient, and should not be overridden without very good reason.

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/sql_iterator.rs#L33)
impl [StructuralPartialEq](https://doc.rust-lang.org/1.98.1/core/marker/trait.StructuralPartialEq.html) for [SqlParameters](https://docs.kinetica.com/content/api/rust/sql_iterator/enum.SqlParameters.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.