---
title: "Adding API Aliases to SQL Fields | DreamFactory"
description: "How to expose a SQL column under a different name in the API, so awkward or legacy column names do not leak into your public contract. A short, focused…"
url: "https://www.dreamfactory.com/videos/sql-field-api-aliases"
---

[Home](https://www.dreamfactory.com/) › [Videos](https://www.dreamfactory.com/videos) › Adding API Aliases to SQL Fields

# Adding API Aliases to SQL Fields

Tutorial·19 February 2016·2 min 47 sec

How to expose a SQL column under a different name in the API, so awkward or legacy column names do not leak into your public contract. A short, focused tutorial.

**Recorded in 2016.** The concepts still apply, but the interface shown predates the current DreamFactory release. Some steps may differ in the current release.

## What you’ll learn

* Renaming a SQL column at the API layer
* Keeping legacy column names out of a public contract
* Where aliases are configured per field

[Book a Demo](https://www.dreamfactory.com/demo)[More on our YouTube channel](https://www.youtube.com/@DreamfactoryAPI)

## More videos

* [Creating Calculated Virtual SQL Fields](https://www.dreamfactory.com/videos/calculated-virtual-sql-fields)
* [Adding Your Own Custom API](https://www.dreamfactory.com/videos/custom-api-endpoints)
* [Setting Up the Address Book Sample Application](https://www.dreamfactory.com/videos/address-book-sample-app)
* [Using Data Mesh and Virtual Foreign Keys](https://www.dreamfactory.com/videos/data-mesh-virtual-foreign-keys)

[Browse all videos ›](https://www.dreamfactory.com/videos)

Video: https://www.youtube.com/watch?v=T5u9NNeFkUU