# Create Dynamic Views with jOOQ 3.17's new Virtual Client Side Computed Columns

DevFeed: [Create Dynamic Views with jOOQ 3.17's new Virtual Client Side Computed Columns](<https://devfeed.tech/articles/create-dynamic-views-with-jooq-3-17-s-new-virtual-client-side-computed-columns-28936.md>)

Original publisher: [Read original article](<https://blog.jooq.org/create-dynamic-views-with-jooq-3-17s-new-virtual-client-side-computed-columns/>)

Author: lukaseder

Published: 2022-06-30T14:46:35Z

Content type: article

Language: en

Sources: [jOOQ](<https://devfeed.tech/sources/jooq.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>)

Tags: [client-side-computed-columns](<https://devfeed.tech/tags/client-side-computed-columns.md>), [computed-columns](<https://devfeed.tech/tags/computed-columns.md>), [java](<https://devfeed.tech/tags/java.md>), [jooq](<https://devfeed.tech/tags/jooq.md>), [jooq-3-17](<https://devfeed.tech/tags/jooq-3-17.md>), [jooq-development](<https://devfeed.tech/tags/jooq-development.md>), [maven](<https://devfeed.tech/tags/maven.md>), [sql](<https://devfeed.tech/tags/sql.md>), [virtual-client-side-computed-columns](<https://devfeed.tech/tags/virtual-client-side-computed-columns.md>), [virtual-computed-columns](<https://devfeed.tech/tags/virtual-computed-columns.md>)

## AI overview

This article explains jOOQ 3.17's client-side computed columns, which let developers define computed expressions that are substituted into SQL statements or evaluated when values are written. It contrasts them with server-side computed columns and discusses using the feature to create dynamic view-like behavior without database views.

## Source excerpt

One of jOOQ 3.17's coolest new features are client side computed columns. jOOQ 3.16 already added support for server side computed columns, which many of you appreciate for various reasons. What's a computed column? A computed column is a column that is derived ("computed") from an expression. It cannot be written to. It works like ... Continue reading Create Dynamic Views with jOOQ 3.17's new Virtual Client Side Computed Columns ->