# What's missing?

[Home](/rezoom-sql/master.md) > [Language](/rezoom-sql/language.md) > What's missing?

[← Dynamic SQL](/rezoom-sql/language/dynamicsql.md) | [API →](/rezoom-sql/api.md)

## What's missing?

If you are already familiar with a SQL dialect, here are some features you may miss that are not currently supported by RZSQL.

For many of these, you can use [vendor statements](/rezoom-sql/language/vendorstatements.md) to trade type safety for access to your database backend's special features.

### On the horizon

These features, while not currently supported, fit in well with RZSQL's design goals and would make sense to add eventually. Pull requests would of course be appreciated!

* Support for mixing dynamic SQL into static queries, especially `ORDER BY` clause
* Window functions
* Table-valued functions
* User-defined functions
* Enums
* Local variables in queries
* Inline (at F# compile-time) views and user-defined functions
* `json` and `xml` data types with some dynamic query operations

### In my dreams

These features are considered desirable, but would be more difficult to fit into RZSQL's design. I probably won't get around to adding them unless I'm around to work on this project [a long time](https://www.youtube.com/watch?v=izQB2-Kmiic):

* Interpreted in-memory implementation of each DB backend, for easy unit testing
* Linq-ish query builder using the type provider's database model
* Statically typed (w/ schema) JSON/XML access
* Custom data types (e.g. Postgres range types)

### In my nightmares

These features will **never** be added. You can use vendor statements for them though!

* General-purpose programming features (`IF`, `WHILE`, cursors)
* Stored procedures

***

[← Dynamic SQL](/rezoom-sql/language/dynamicsql.md) | [API →](/rezoom-sql/api.md)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://humbobst.gitbook.io/rezoom-sql/language/missingfeatures.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.